…performance of InnoDB significantly during the hot run, as hash indexes are faster than a b-tree index. Also accessing pages …justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn… cause small tablespaces to expand too fast around 500KB tablespace size. Bug fixed #1169494. Fixed the RPM package dependencies issues. Bug…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
… changed page data. Bug fixed #1108613. Percona Server wouldn’t start if the XtraDB changed page tracking was enabled and variable innodb_flush… a zero-size bitmap file at the right moment would make server stop with an I/O error if changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… TokuDB shows about 2.8x better throughput, and on data size: InnoDB table: 58GB and 244.980.192 records TokuDB table: 15GB… SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves …files of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So, …you look at the Linux settings for the dirty pages. You can either set “vm.dirty_ratio” or “…
Post: InnoDB page size
June 4, 2006 By 4 Comments
As maybe you know InnoDB uses hard page size 16Kb for datafiles and for buffer pool. However this size can be changed if you… of UNIV_PAGE_SIZE: */ #define UNIV_PAGE_SIZE_SHIFT 14 UNIV_PAGE_SIZE is page size (as you see – default value 16Kb). Possible values for UNIV_PAGE_SIZE is 8K… UNIV_PAGE_SIZE_SHIFT (according comment it must be 2-logarithm of UNIV_PAGE_SIZE). For pagesize 8K – UNIV_PAGE_SIZE_SHIFT=13, for 32K – UNIV_PAGE_SIZE…
Post: InnoDB page sizes: plans and ideas
April 21, 2011 By 9 Comments
It is well known fact that InnoDB standard page size is 16K or 16384 bytes. Sometime ago we added feature to Percona Server to change that to 4K or 8K (innodb_page_size… area for improvements: support 32K and 64K pages. Why this is needed ? For InnoDB compression. Right now if you use 16K and…
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…
