… years after MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full… tune our customers’ MySQL 5.6 test and production environments, and address any performance issues that might arise. Our MySQL Training team is…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… fine tuning Innodb Contention with number of spin locks loops is something i would consider last resort tuning, the performance improvements it provides… time while you’re upgrading to Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of competing…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention…list, there are several others that can be performed with existing plugins, so there was no need… and try out the plugins, and help us improve them. If you are a customer and …
Post: Few more ideas for InnoDB features
June 29, 2009 By 7 Comments
As you see MySQL is doing great in InnoDB performance improvements, so we decided to concentrate more on additional InnoDB features, which will make difference…/03/30/my-hot-list-for-next-innodb-features/ (and one of them – moving InnoDB tables between servers are currently under development…
Page: Presentations
May 3, 2006 By
…. Download MySQL/Innodb Performance: Server and Schema MySQL Users Conference 2004, Orlando, FL Presentation shows how much you can improve performance by adjusting schema and MySQL Server… storage engine. Download MySQL/Innodb Performance: OS and Hardware MySQL Users Conference 2004, Orlando, FL Presentation shows how much you can improve performance by OS setting…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… other possibilities like InnoDB doing read_ahead by noticing the sequential access pattern. BKA is available in both MySQL 5.6 and… MRR performance, and BKA uses the MRR interface, so these buffers indirectly impact BKA performance. I did not find much of a performance improvement…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb_rows… improvement and changes needed in the optimizer’s cost estimation algorithm. MariaDB 5.5 expands the concept of MRR to improve the performance… index tuples fit in the buffer. But there is no performance improvement when the workload is in-memory, in fact MRR adds…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_…WT cache enabled, single thread performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…at Launchpad. Highlights Performance Improvements fsync() has been replaced with fdatasync() to improve perfomance where …for the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum… Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… consider this as equivalent to the number of threads inside InnoDB, or to the Threads_running SHOW STATUS counter, without much… reduced mutex contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This…
