…’m 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 be compressed… data size is almost 30% larger with 4K pages. In this case Percona Server 5.5 was tested, which allows changing page size without…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
…. Why did we choose a KEY_BLOCK_SIZE that is the same value of the InnoDB page size of 16KB? As the fine MySQL… must be running with innodb_file_per_table=1 as the InnoDB system tablespace cannot be compressed, see this page for further details…-operation like this: ALTER TABLE `t1` ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16; In our case even though the customer…
Post: Looking for InnoDB/XtraDB hacker
October 25, 2011 By 3 Comments
…-two-biggest-innodb-problems/ Make some InnoDB tables non-transactional 
Make InnoDB page size setting per tables and per index Specify location of InnoDB tables (e.g: disk or SSD) Make InnoDB…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Innodb_os_log_writtenblogpercona.commanual Innodb_page_sizeblogpercona.commanual Innodb_pages_createdblogpercona.commanual Innodb_pages_readblogpercona.commanual Innodb_pages_writtenblogpercona.commanual innodb_purge_batch_sizeblogpercona.commanual innodb_purge_threadsblogpercona.commanual innodb…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 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… 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: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things… 10%) larger than your data (total size of Innodb TableSpaces) because it does not only contain data pages – it also contain adaptive hash… clean page from Buffer Pool while Innodb can simply discard that pages in case of memory pressure. But what is more important Innodb algorithms…
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) Q5: When Innodb free space becomes available for use within same object? When does Innodb make…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… one page thus reducing performance. This is especially the problem as you have to specify single page size for Innodb table, while data pages and pages for different indexes may well have very different compression ratio. As Innodb indexes are…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… it. How blobs are stored in Innodb ? This depends on 3 factors. Blob size; Full row size and Innodb row format. But before we… 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…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… as with innodb_file_per_table=1 allowing to flush all of modified tablespaces in the parallel. Multiple page sizes. One size does not… specify page size per object or at least per tablespace would be great. This will complicate buffer management a bit but Innodb is already to deal with 2 page sizes by supporting compressed pages so it might be not…
