…s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the … Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the…performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5…A 0 0 0 Handler_mrr_rowid_refills N/A N/A N/A 22 0 0 …performance. I did not find much of a performance improvement from using Hash Join in MariaDB 5.5…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…MySQL 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…MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL 5.0…MySQL versions are used is typically when application is not overly demanding so performance…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… output of iostat.) I would characterize this as very good performance. Sub-millisecond latencies to disk, pretty much consistently, for reads… 0.0 0.0 0.0 0.0 0.0 2.5 0% 0 23.2 sdi2 0.0 0.0 0.0 0.0 0.0 2.0 0% 0 23.2 sdj5 0.0 0.0 0.0 0.0 0.0 1.0 0% 0 23.2 sdi4 0.0 0.0 0.0 0.1 0.0 2.2 1% 0 23.2 sdi3 0.0 0.0 0.0 0.1 0.0….1 0.0 0.0 3.7 2% 0 21.2 sdj1 0.2 0.1 10.2 0.0 0.0 2.5 2% 0 22.2 sdj1 0.4 0.3 19.1 0.0 0.0 1.0…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is …but in batches reads. So let us see how perform 5.1 and 6.0 in cold mode (I dropped OS caches …65362.27 4.87 247.70 0.27 0.52 0.52 27.22 dm-0 0.00 0.00 542.60 0.61 130724.54 4….
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 7 Comments
… assigns the new value to the column. Prior to MySQL 5.1.22 InnoDB used a method to access that counter values called… and performance. The problems are even worse with long running queries like INSERT INTO table1 … SELECT … FROM table2. In version 5.1.22… method changing the innodb_autoinc_lock_mode to 0. But with a loss of performance and concurrency. How can I solve this…
Post: Using UNION to implement loose index scan in MySQL
August 10, 2006 By 15 Comments
… fact about MySQL Indexing, however very important for successfull MySQL Performance Optimization is understanding when exactly MySQL is … This however looks like a bug in the MySQL 5.0.18 I’m using for this demo. …set (0.06 sec) mysql> SELECT SQL_NO_CACHE name FROM people WHERE age BETWEEN 18 AND 22 …
Post: UNION vs UNION ALL Performance
October 5, 2007 By 13 Comments
When I was comparing performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I should be using … test.abc where i=5 union select * from test.abc where j=5 This original query was taking about 22 seconds. As I… (which uses index merge method in MySQL 5.0): select * from test.abc where i=5 or j=5 Such query takes 4 seconds so…
Post: mysql-proxy, urgh performance and scalability ?
June 9, 2009 By 27 Comments
… question which come in mind is what performance penalty we have using mysql-proxy, version 0.7.1. So it is easy to…-5.0.77MySQL-proxy+MySQL-5.0.77 1 660.02 349.86 2 1158.66 477.77 4 1223.84 485.21 8 1224.22… thread). MySQL per-request statistics: min: 1.31ms avg: 1.51ms max: 5.30ms approx. 95 percentile: 1.56ms Proxy+MySQL per-request…
