… MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB… 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: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 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: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… less lock contention, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all…MySQL that suit different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL…
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: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… innodb innodb_data_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush… in set (15 min 54.29 sec) Please help to improve performance and suggest if any config changes are to be made…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… our last major release on improving the reliability and user experience…In previous versions streaming backups were performed by the innobackupex script but… XtraBackup against debug versions of InnoDB. This is only for very …at the upcoming Percona Live MySQL Conference and Expo (register now!). …
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
March 7, 2012 By 21 Comments
I am using AWS MySQL RDS, InnoDB engine. Our requirement is to insert data in same table … 14min time be reduce further? Is there anyway I can improve the performance? We can use OUTFILE method as suggested by Peter…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
…a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what … of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy Zawodny …? Have some updates made to INNOdb tables really slowed down mySQL as measured by qps, in…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… of days ago I was looking for a way to improve update performance for the application and I was replacing single value… 10 in the batch performance improved, especially for network tests, however going to batches of 100 and 1000 values performance started to degrade… may be kind of performance bug of 5.0. At row0sel.c:row_search_for_mysql() “PHASE 3:”, InnoDB judge whether the SQL…
