…Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your …of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs …
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… the performance issue. Still MYSQL load was very high but site was not going down. Then we did some R&D on Percona MYSQL… performance was good. But from second day again performance degradation started and now it is slow again. MySQL load is not going very high… (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… higher numbers from NDB and 5.5.x clusters with not just simple queries or simple transactions but high concurrency with complex transactions… far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… are interested in PXC as a high-availability solution. But, what they…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… bound on performance, only a upper bound. The best performance you can… (I usually get less than 5 people who do out of 100…
Comment: Why MySQL Performance at Low Concurrency is Important
March 31, 2013 By 8 Comments
…/mysql-56-single-threaded-read-only.html. All of the conclusions assume a benchmark with fast (100 to 200 usecs) queries: * performance_schema overhead is too high for benchmarks * innodb_checksum_algorithm=CRC32 is a big win * 5.6 was ~9…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE_SCHEMA… on MySQL 5.6 with default configuration back_log Minor increase 50 to 80 does not make much difference. Systems with high number…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… with high concurrency compared to single thread ? Note Sysbench is simple enough it does not take advantage of any of new MySQL 5… single thread MySQL 5.5 is 11% faster than MySQL 5.6. If you disable Performance Schema in MySQL 5.6 comes to just about 3% showing Performance Schema… MySQL 5.5 is 26% faster compared to MySQL 5.6 and if you disable Performance Schema the difference is still 11% with 13% difference between MySQL 5…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
…MySQL is an enhanced drop-in replacement for MySQL, offering breakthrough performance, scalability, features, and instrumentation. Self-tuning algorithms and support for extremely high-performance…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… performed, on the hash table we created earlier. This step is known as probe step. This join algorithm works best for highly… 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…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5… see from the status counters above that both MySQL 5.6 and MariaDB 5.5 are reporting high numbers for Innodb_buffer_pool_read_ahead…
