… Innodb_os_log_writtenblogpercona.commanual Innodb_page_sizeblogpercona.commanual Innodb_pages_createdblogpercona.commanual Innodb_pages_readblogpercona.commanual Innodb_pages_writtenblogpercona.commanual innodb_purge_batch…_write_requestsblogpercona.commanual Key_writesblogpercona.commanual languageblogpercona.commanual large_files_supportblogpercona.commanual large_page_sizeblogpercona.commanual large_pagesblogpercona.commanual last_insert_idblogpercona.commanual Last…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… database is large so you need large buffer pool, if not – setting buffer pool a bit larger than your database size will be… to check if there are any restrictions on Innodb Buffer Size you can use. Typically you would see restriction applying only… memory adjustments. You may want to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which…
Comment: MySQL Server Variables - SQL layer or Storage Engine specific.
December 1, 2006 By 14 Comments
… I saw the following: show variables like ‘%large%’; +———————+———+ | Variable_name | Value | +———————+———+ | large_files_support | ON | | large_page_size | 2097152 | | large_pages | ON | +———————+———+ 3 rows in set (0… something? – Can I assume that the large_page_size here is 2097152 kB? So it uses 1048 pages of 2M? – Must I use the…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… list so SHOW INNODB STATUS output will not grow too large. Transaction id is current transaction identifier – it is incremented for… avg bytes/read” shows average size of read requests. For random IO these should be 16K – page size, for full table scan or index scan read-ahead may be performed which can increase average read size significantly. So…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… the page data size drops below this limit, merging it to a neighbor is tried */ #define BTR_CUR_PAGE_COMPRESS_LIMIT (UNIV_PAGE_SIZE / 2…. Q7: Does Innodb has any protection from pages being overwritten in buffer pool by large full table scan HT: No PZ: Another… text/blob in the page and will allocate some space outside of the page. However: 1. if the total size of the row…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… to advice on the compression page settings by looking at compressed page size distribution you can tell which page size will be optimal – will allow to get maximum compression while limiting amount of pages which… should be much faster for IO Bound Index scans and large range scans. We surely should benchmark this aspect separately. Improved…
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
How does Buffer Pool size affects Innodb Performance ? I always expected the effect to be positive, Innodb with large buffer pool to… over 20GB. Innodb recovery was taking long hours with reasonably sized Innodb log files (256M) gradually progressing slower and slower so… while recovery was going with large buffer pool) plus large distinct amount of pages modified so a lot of pages had to be added…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…apply to MyISAM as key_buffer itself. large_pages – Use of Large Pages for allocation of large global areas such as Innodb Buffer Pool, Key…but currently implemented only for Innodb. tmp_table_size This variable specifies maximum size implicit temporary table (created during query execution …
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
Monty Taylor posted interesting investigation of the fact read_buffer_size variable affects connection speed. This is not something you would… they are forced to deal with very large blocks. The second possibility is to use large pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for other large allocations…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase recovery… let me explain what happens on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb… IO to check if pages are up to date), number of unflushed pages in innodb buffer pool and its size as well as…
