…0.000000 | 0 | 0 | 0 | 0 | 1 | 1 | | 13 | end | 0.000027 | 0.000026 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 1 | 1 | | 4 | checking permissions | 0.000015 | 0.000014 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 0 | 0 | | 15 | closing tables | 0.000015 | 0.000016 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0 | 0…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is a lot… 3791.38 5.75 8.03 1.01 1.07 1.07 101.40 dm-0 0.00 0.00 944.97 0.62 7582.75 4.93 3791….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… 0.20 526.77 1.01 130724.54 9.74 65362.27 4.87 247.70 0.27 0.52 0.52 27.22 dm-0 0.00 0…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “fits in memory… 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… observed. Vadim has already Wrote about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
…. Versions in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are…. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5.0 grammar became… (more is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596.01…
Post: UNION vs UNION ALL Performance
October 5, 2007 By 15 Comments
… performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I …in MySQL 5.0): select * from test.abc where i=5 or j=5 Such query takes 4 seconds… from test.abc where j=5 and i!=5) \G *************************** 1. row *************************** id: 1 select_type: PRIMARY table: abc …
Comment: Quick comparison of MyISAM, Infobright, and MonetDB
October 1, 2009 By 30 Comments
Why you don’t put the version used of each software? that’s is very important!! there are differences between infobright 3.1.1 and 3.2 (ICE vs IEE), MySQL 4.1 vs 5.0 vs 5.1, for example.
Post: Using index for ORDER BY vs restricting number of rows.
February 16, 2007 By 8 Comments
… goods where cat_id=5 and seller_id=1 order by price desc limit 10 \G *************************** 1. row *************************** id: 1 select_type: SIMPLE table… 1 row in set (0.00 sec) mysql> explain select * from goods force index(cat_id) where cat_id=5 and seller_id=1… key: cat_id key_len: 4 ref: const rows: 989171 Extra: Using where 1 row in set (0.00 sec) As you can…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…replication thread was busy replicating events vs staying idle. Note you can …5.75k 124.25 # Bytes sen 1.94M 0 9.42k 1.67 0 110.38 0 # Killed 0 0 0 0 0 0 0 # Last errn 34.11M 0 1.55k 29.26 0…4.15k 0 1 0.00 0 0.06 0 # Tmp table 14.19k 0 2 0.01 0 0.14 0 # Tmp table 8.30G 0 2.01M 7.12k 0 117.75k 0 # 0…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…lower, the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important …in_prg {540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% 0.0 0.6 85% 0 Misaligned: #ts device …prg {925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0 While number of…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… execution time, the number of tmp tables created in memory vs on-disk, percentage of queries that needed full scan, InnoDB… 0.1381 1.7% 909 0.0002 1.00 0.00 SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0.0987 1.2% 50 0.0020 1…
