… set innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb… the free list via buf_flush_free_margin. I did a lot of work for the innodb_fast_free_list option to… in 5.6. In 5.6 a background thread, buf_flush_page_cleaner_thread, should be moving all pages to the…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… set innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb… the free list via buf_flush_free_margin. I did a lot of work for the innodb_fast_free_list option to… in 5.6. In 5.6 a background thread, buf_flush_page_cleaner_thread, should be moving all pages to the…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the… fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the… fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES… a typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
One more bug that explains why LRU page flushing rate is much less than innodb_lru_scan_depth even if innodb_lru_scan_depth is large enough. Apparently fixed in 5.6.12 — http://bugs.mysql.com/bug.php?id=69170
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… flushed. That is, for example, we see that to make an improvement in the checkpoint_age we need to flush 8 pages. InnoDB flushes… this (alas, 8 pages flushed). That is, instead of flushing 8 pages what we would expect to be flushed, InnoDB flushes 1 needed page and… why innodb_adaptive_flushing is not able to keep up. What if we disable flushing of neighbor pages (we have the option innodb_flush_neighbor…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… intensive writes, InnoDB is using LRU list flushing. So why is it important to know what the mix of InnoDB flushing types is in… flush list bound, then for MySQL 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file…
Post: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a … crash. In fact, InnoDB has two protection points: “async” and “sync”. When checkpoint_age reaches “async”, InnoDB tries to flush as many pages… is even worse. When we reach “sync”, InnoDB blocks other queries while trying to flush pages and return checkpoint_age to a…
