… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the…_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… for 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… counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer…/A N/A N/A 0 0 0 Handler_mrr_rowid_refills N/A N/A N/A 22 0 0 Handler_read_key 1829910 4440511…
Comment: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
March 11, 2012 By 7 Comments
Dear Miguel mysql from 5.1.22 change autoincrement mod http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html I… your my.ini file. # =0 is traditional lock mode == > funcionality of auto_increment like before 5.1.22 # =1 is default value – consecutive…’t investigate what it do innodb_autoinc_lock_mode=0 2. restart mysql server now is working perfectly id – is primary key…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
…3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24…99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! …the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… Percona Server 5.5.16-22.0 on October 14, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug fixes in it, Percona Server 5.5.16-22.0 is now the current stable release in the 5.5… the details of the release can be found in the 5.5.16-22.0 milestone at Launchpad. New Features InnoDB Fake Changes When…
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… time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99… set MySQL 5.1 could only complete 10 out of 22 queries within 3hours run time allowed for each query and MySQL 6.0 has…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
When I started with MySQL 3.22 I would start running MySQL from early beta (if not alpha) and update MySQL the same date… on 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 which… see something like MySQL 5.0.44 which went in as release in some of distributions. As many people use MySQL releases which come…
Post: MySQL 5.1 went to GA. Was it a good move ?
December 10, 2008 By 4 Comments
… do I think MySQL 5.1 Quality Stands ? I’ve been MySQL user for years since version 3.22 and when MySQL 3.23 came… bright side MySQL 5.1 “GA” quality was much better than MySQL 5.0 quality when it was released. Though the question remains, was MySQL 5.1 release as GA now a good move ? MySQL 5.1…
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 a… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice… 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.87…
Post: MySQL sources from development tree
January 9, 2007 By 1 Comment
…-5.0.32-build TAG: mysql-5.0.30 TAG: clone-5.0.30-build TAG: mysql-4.1.22 TAG: clone-4.1.22-build TAG: mysql-5.0.28 TAG: mysql-5.0.27 TAG: mysql-5.0.26 So, to get sources for 5.0.30…
