… long) | buf_LRU_get_free_block(buf_pool_t*) | | | |–94.84%– buf_page_init_for_read(dberr_t*, unsigned long, unsigned…_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… await svctm %util sda 0.00 0.41 317.83 0.82 2570.49 9.84 1285.25 4.92 8.10 1.02 3.20 3.20 102.01 dm-0 0.00 0.00 317.83 0.61… 1244.26 5.74 8.05 1.02 3.28 3.28 101.84 dm-0 0.00 0.00 309.63 0.61 2488.52 4.92 1244.26 2.46 8.04 1.02…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… one query is ran concurrently, same can be told about 8 hard drives which this box had. MySQL Also was very… number of queries. Honestly I expected more from MySQL 6.0 optimizer improvements effort. 100GB Results are more interesting because this… a lot of talks about optimizer improvements in MySQL 6.0 I expected drastically better results. Though may we should not…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
….8 43.2 | 70.9 0.1 277.6 401.6 43.8 421.5 | 336.8 1.6 239.7 414.8 44.0 | 84.7 0.1 228.2 394.2 45.6 534.2 | 426.8 3.1 190.0 348.7 41.2 | 107.4 0…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… 7.50G 0 128.00k 4.49k 15.96k 8.37k 0 # IO r ops 50 480.18k 0 8 0.28 0.99 0.52 0 # IO r wait 55 3949s 0 466ms 2ms 12ms 7ms 0 # pages distin 65 11.43M 1 18 6.84 9.83 2.20 7.70 # queue wait 0 0 0 0 0 0 0 0 # rec lock wai 0 0 0 0 0 0 0 0 # String: # Databases # Hosts localhost…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
…0 | 5 | 242 | 0 | 3 | 0 | 8 | 7 | unknown | | | | | 7 | 0 | 6 | 3006 | 0 | 0 | 0 | 9 | 6 | unknown | | | | | 8 | 0 | 45 | 0 | 0 | 0 | 0 | 10 | 2 | undo_log | | | | | 9 | 0 | 50 | 0 | 0 | 0 | 0… | 15095 | 0 | 0 | 51 | 17855 | index | PRIMARY | art | author87 | | 84 | 1 | 3799 | 139 | 15144 | 0 | 0 | …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
….52k 84.36k 81.56k 83.83k 7.31k 79.83k # Merge passes 0 0 0 0 0 0 0 0 # Tmp tables 0 0 0 0 0 0 0 0 # Tmp disk tbl 0 0 0 0 0 0 0 0 # Tmp tbl size 0 0 0 0 0 0 0 0….84 # Rows examine 8 45.05k 0 1.05k 309.59 1012.63 299.07 124.25 # Rows affecte 0 0 0 0 0 0 0 0 # Rows read 8 9.01k 0 216 61.90 202.40 59.80 24.84 # Bytes sent 1 622…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… (SELECT carrier,count(*) as totalflights,sum(if(depdelay>10,1,0)) as ndelayed from ontime where year=2007 group by carrier… For reference I used 5.1.36-Tokutek-2.1.0 for both MyISAM and TokuDB tests. And if you are….521.8378.42NA Q7187.2227.98.59106.37NA Q8 (1y)8.750.551.746.768.13 Q8 (2y)102.171.13…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…white;font-family:arial,sans,sans-serif;font-size:100.0%;font-weight:normal;font-style:normal;color:#000000;text-decoration…7 year27.5894.8332.2482.14327.5890979766854.83267164230352.24800109863282.1432509422302.8 year32.1485.6122.4472.49632.1476650238045.61204981803892.44708514213562.4959940910339.9…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…0.000049 | 0.000117 | 0.000000 | 0.001000 | 0 | 0 | 0 | 0 | 3 | 3 | | 8 | optimizing | 0.000048 | 0.000048 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 8 | 8 | | 7 | System lock | 0.000031 | 0.000031 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0…
