… using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could… data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was DYNAMIC row format. After 3… data file and 30% drop in our I/O load. This was related to the fact that with DYNAMIC row format InnoDB was…
Post: Future InnoDB File Formats
April 15, 2008 By 14 Comments
Looking into InnoDB docs I found list of names of future InnoDB file formats: Antelope, Barracuda, Cheetah, Dragon, Elk, Fox, Gazelle, Hornet, Impala, Jaguar…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
New features of InnoDB – compression format and fast index creation sound so promising so I spent … dump into table with default format and all indexes (case 1) – 152m34.792s size of final .ibd file for (case 1) – 43032M What if load data and indexes separately: load dump into table with default format and without…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_writesblogpercona.commanual innodb_doublewriteblogpercona.commanual innodb_fast_shutdownblogpercona.commanual innodb_file_formatblogpercona.commanual innodb_file_format_checkblogpercona.commanual innodb_file_format_maxblogpercona.commanual innodb_file_per_tableblogpercona.commanual innodb_flush_log…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…innodb(a int, b int) engine=innodb; Query OK, 0 rows affected (0.30 sec) Check out files (using Innodb File…InnoDB DEFAULT CHARSET=utf8 mysql> show table status like “test_innodb” \G *************************** 1. row *************************** Name: test_innodb Engine: InnoDB Version: 10 Row_format…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… lock, heap no 5 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 80000002; asc ;; 1… helper threads, on Windows it however can be adjusted by innodb_file_io_threads variable. For each helper thread you can see… subsystem of Innodb. You can see current log sequence number – which is amount of bytes Innodb has written in log files since system…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… they lost the ibdata1 file, where all the table meta-data is stored. Fortunately, they were running with innodb_file_per_table so the data itself was available. What they could provide us was: all the tables ibd files (Nearly… clean MySQL install so that Innodb tablespace id is set to 1 Import the schema in MyISAM format to avoid screwing up…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_DIRECT innodb-ibuf-active-contract=1 innodb-import…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… 500 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir /rdsdbdata/db/innodb innodb_doublewrite ON innodb_fast_shutdown 1 innodb_file_format Antelope innodb_file_format_check Barracuda innodb_file_per_table ON innodb…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… normally set innodb_log_file_size large. We however usually recommend caution as it may significantly increase recovery time if Innodb needs to… 40 minutes or so with innodb_log_file_size=256MB. In other cases I know same log file time may have recovery time… log files from last checkpoint time it looks at records and checks if these are already applied to the pages (Innodb log format…
