…_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 case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
….24 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_flush….20 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_flush…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 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: Adventures in archiving
February 11, 2013 By 16 Comments
…` varchar(1000) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4; CREATE TABLE `non… using compress() ) compressed_row (The row format being set to compressed, ensure you have innodb_file_format Barracuda as Antelope does not support compression…:1 304M InnoDB row_format=compressed key_block_size=4 4.04:1 648M compress() 1.897:1 1.2G InnoDB 1:1…
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…
Comment: Future InnoDB File Formats
April 17, 2008 By 14 Comments
… the google reader: Future InnoDB File Formats from Planet MySQL author: Peter Zaitsev At the Planet Mysql: Future InnoDB File Formats posted by Peter Zaitsev on…
