…the process when using pvcreate to initialize disk for LVM use, the two options you are interested in are…are not aligned. Now it may be interesting to see what are real life effects of misalignment, my benchmark results are in the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…what the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot? Sometimes there are rigid constraints on what…are the lowest common denominator. We often use tools to gather a lot of the data for us and speed the process, when possible, but the… 2.00GHz stepping : 11 cpu MHz…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…triggers” such as Gearman jobs. CDC tools usually operate in one of the following ways: Timestamps (usually more than … it a HUP signal. The script will drop a .pid file so you know what process to HUP. $ ./consumer_…11 fv$server_id: 999 c1: 1 c2: 1 3 rows in set (0.00 sec) As you can see, there are…
Post: Is your MySQL Server Loaded ?
March 19, 2010 By 4 Comments
…_running | 1 | | Threads_running | 11 | | Threads_running | 1 | This corresponds to what is…what value of Threads_running represents. This is amount of queries which are being currently processing – the ball is on Server side. The…operation is blocked because of slow network or the client. Because the…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…the data was split before loading. The splitting/loading process will be described in another post. Complex queries Shard-Query was tested with the…the from clause” are used. There are benefits with both “scale-up” and “scale-out”, but once again, the “scale-out” results are the…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…and 53.03 system time consumed by the process. Collecting these at regular intervals and …operation per second which takes 4ms which adds up pretty well. We can also see what the… 12ms 7ms 0 # pages distin 65 11.43M 1 18 6.84 9….to 10-100 ms. The queries which are in 100us range are ones where no IO …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…processing over up to 20 nodes. The Infobright Community Edition (ICE) images are…what airline offered those flights and the flight number of the…operations. This will have a direct impact in our query response times and throughput. Setting up a cluster using the…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…the system. What I usually look for MySQL is performance in random reads and random writes. Sequential reads and writes are rarely the…Operations performed: 773835 Read, 0 Write, 0 Other = 773835 Total Read 11.808Gb Written 0b Total transferred 11… see only 1 blocked process all the time which does …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…are created by FlexCDC. The refresh algorithm computes changes in multiple transactions. After each transaction it must wait for FlexCDC to process…what the COMPLETE refresh method does during its operation. It also takes care of atomically* replacing the new contents of the view with the…43 min 10.11…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… the compression utility should utilize several CPU to speedup operation, and another my requirement was the… -1 and -5 for other tools) The raw results are available here http://spreadsheets.google….compression, but the speed of processing is too slow. What is interesting on Level 5 the compression …
