… set innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb… for moving pages to the free list via buf_flush_free_margin. I did a lot of work for the innodb_fast… it is hard to know what goes on behind the large wall between us and them. http://bugs.mysql.com/bug…
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… for moving pages to the free list via buf_flush_free_margin. I did a lot of work for the innodb_fast… it is hard to know what goes on behind the large wall between us and them. http://bugs.mysql.com/bug…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… standby server will not have recently accessed pages. When it starts handling queries after failover, …-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and … reuse. This is necessary when running a large stream of queries. Benchmarks We benchmarked with …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…user queries, making it ideal for companies with large data sets and mission-critical applications that …MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed ….1. Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now…
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: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… large number of connections Innodb will only print number of them, cutting the list so SHOW INNODB STATUS output will not grow too large… buffer efficiency. Adaptive hash index is hash index Innodb builds for some pages to speed up row lookup replacing btree search with… IO submited by Innodb – pages to be flushed via LRU pages – dirty pages which were not accessed long time, flush list – old pages which need…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… query thread normally posts about 64 page read requests per a readahead. The InnoDB buffer is 256 page read requests for the aio… mature. We improved the scalability of InnoDB-5.0.30 in December 2006 with a large patch, and the ‘last’ serious bug… fairly large Innodb table (150GB) that is showing poor performance for full table scans. using O_DIRECT, we are seeing individual 16KB paged…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… in before Innodb plugin and named “Antelope” in Innodb Plugin and XtraDB) Innodb would try to fit the whole row onto Innodb page. At least 2 rows have to fit to each page… in the single large Blob (and potentially compress it) If all columns do not fit to the page completely Innodb will automatically chose…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase… happens on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find… need random IO to check if pages are up to date), number of unflushed pages in innodb buffer pool and its size as…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
… when you think you are because Innodb caches data in pages, not rows, and so the whole page needs to be in memory… trying standard Innodb page size, 4KB page size as 16K page size compressed to 4. The data in this case compresses perfectly (all pages could…. It is hard to see from the graph but with large number of keys compressed results were best of all, probably…
