…) ) Engine=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â Â ‘First… row size, which is slightly less than half a database page (the actual math is 16k-(page header + page trailer)/2. For the default page size of 16kb. this sets an ~8000 bytes limit on row size…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… default are bigger in size – I would often see see 64KB (mdadm default chunk size) or 128KB stripe unit size…you can now customize page size and it may be good idea to check that page size is no … will be talking here about InnoDB data pages which are 16KB in size. File system File system plays …
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… index record, and the remainder stored in overflow pages. COMPACT became the default after MySQL 5.0.3 and has a more compact… only wanted MySQL to try to move the larger (greater than 16KB) TEXT fields off-page so we utilized the KEY_BLOCK_SIZE=16… choose a KEY_BLOCK_SIZE that is the same value of the InnoDB page size of 16KB? As the fine MySQL manual states: This setting…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
… I’m pretty confident running Innodb with both default (fsync based) or O_DIRECT innodb_flush_method….I’m comparing O_DIRECT and fsync() single page writes to 1MB file using SysBench on Ubuntu,… 1 files, 1Mb each 1Mb total file size Block size 16Kb Number of random requests for random IO: 10000000…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…in size with 1, 4 and 8 threads. The operations were done in 16kB units to mimic InnoDB pages….32-bit xfs inodes (which are used by default) have to live in the first terabyte of…different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… ) ENGINE=InnoDB AUTO_INCREMENT=26141165 DEFAULT CHARSET=utf8; And size of file is about 12.88 …pages ( 16KB each) and size of data 7492026403 bytes or (6.98 GB). And density ( fitting data into pages…if you are badly missing some features in MySQL, InnoDB, InnoDB-plugin, XtraDB, XtraBackup – you know…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…size (2MB = 128 of 16KB pages) and so will not affect growth of your main Innodb Tablespace. Insert Buffer size…mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | page_no | max_size | curr_size… in default REPEATABLE…
