…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…
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” \G *************************** 1. row *************************** Name: test_innodb Engine: InnoDB Version: 10 Row_format: Compact Rows: 1069 Avg_row_length: 199 Data_length: 212992 Max…
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…=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K #we value…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…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…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… no 5 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 80000002; asc…difference between these values will also grow and innodb_max_purge_lag will become your friend. “undo n:…, on Windows it however can be adjusted by innodb_file_io_threads variable. For each helper thread you…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table max…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb…format the file system. One thing to note however – files…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data_file_path…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data_file_path…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… *************************** Name: t Engine: InnoDB Version: 10 Row_format: Compact Rows: 4195067 Avg_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index…0m0.062s Caveats: As I mentioned previously, InnoDB fast index creation uses temporary files in tmpdir for all indexes being created. So…
