… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… traditional InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also disabled query cache to… cause read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many … MySQL that suit different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 5 Comments
… taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries these might need to… EXPLAIN phase yet making it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search…. In MySQL 5.6 things are likely to get even better handling joins of many tables as optimizer heuristics are improved so…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… this optimization the idea of MRR is further extended to improve join performance. As I told you above, when table t1 would… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read… 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
… were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w… 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: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… better) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn… the lead author of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy Zawodny & Derek Balling…, thanks for your help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… hard since our last major release on improving the reliability and user experience of …backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups…the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, …
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… with slow query output. The tables are in InnoDB with MySQL 5 and RHEL 5. Its a 32 bit machine with… = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool… in set (15 min 54.29 sec) Please help to improve performance and suggest if any config changes are to be made…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, … of three nodes, will it help to improve the response time ? – Do we need to … For example, the famous problem with DROP TABLE performance. Does DROP TABLE, running in separate session, …
