… used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive… 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
… 2.2G Innodb_data_reads 329115 355323 143808 335526 16164 15506 Innodb_pages_read 329115 355323 143808 358308 144798 144881 Innodb_rows_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
….89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_pages_read 120548 123868 100551 123592 100566 Innodb_rows_read 799239… improvement and changes needed in the optimizer’s cost estimation algorithm. MariaDB 5.5 expands the concept of MRR to improve the performance…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
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…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… like less lock contention, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, …different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world as …
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
….cnf|grep 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…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does,… author of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by … board to everyone? Have some updates made to INNOdb tables really slowed down mySQL as measured by …
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…running Percona XtraBackup against debug versions of InnoDB. This is only for very advanced users….
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…; } } The “REPLACE 1000 rows” SQL doesn’t have “SELECT” so, InnoDB scan all of the SQL each times… (* “INSERT” may not…
