…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…whole database instance and you need to mysqldump your data, re-create database and…improvements: support 32K and 64K pages. Why this is needed ? For InnoDB compression. Right …
Post: InnoDB page size
June 4, 2006 By 3 Comments
…InnoDB uses hard page size 16Kb for datafiles and for buffer pool. However this size… page size of the database */ #define UNIV_PAGE_SIZE (2 *…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, 16K, 32K…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size…Innodb (and we have patches for this) Operating System Notes from database…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on your database designed and the… and (approximately) 32K pages for the table data. Both sizes can be set using compile time switches. However, if the index page size is changed…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
…InnoDB storage: first – in Percona Server you can now customize page size and it may be good idea to check that page size…even align to 1k. sda2 aligns up to 32k but the RAID controller actually has 64k stripe… seem there are many moving parts between the database and actual disks, it’s not really all…
