…innodb_max_purge_lagblogpercona.commanual innodb_mirrored_log_groupsblogpercona.commanual innodb_old_blocks_pctblogpercona.commanual innodb_old_blocks_timeblogpercona.commanual innodb_open_filesblogpercona.commanual Innodb…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…INNODB_CONCURRENCY_TICKETS | 500 | 5000 | | INNODB_PURGE_THREADS | 0 | 1 | | INNODB_OPEN_FILES | 300 | 2000 | | INNODB_DATA_FILE_PATH | ibdata1:10M:autoextend | ibdata1:12M:autoextend | | INNODB…not enabled by default. innodb_old_blocks_time now set to 1000 making Innodb Buffer Pool Size scan …
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/…DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = 16 innodb_open_files = 20000 innodb_flush_method = O_DIRECT innodb…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…dates may not be in date_id order’; /*!40101 SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` …innodb-log-buffer-size=32M innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… the open_files_limit set to 40000? 2) Could you explain the difference between MyISAM and InnoDB table cache?…innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = 16 innodb_open_files = 20000 innodb_flush_method = O_DIRECT innodb…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status.
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… far worse on InnoDB. There are a few reasons why this happens — access to open an InnoDB table is … competing. My chosen strategy for this was to set innodb_flush_method=O_DIRECT. We could also tune …S-lock on RW-latch at 0x2aaaae0b70b8 created in file btr0sea.c line 139 a writer (thread id …
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… | | test_innodb | +—————-+ 2 rows in set (0.00 sec) mysql> show create table test_innodb; ERROR 1146 (42S02): Table ‘test.test_innodb‘ doesn’t… [ERROR] Cannot find or open table test/test_innodb from the internal data dictionary of InnoDB though the .frm file for the table exists…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… value. innodb_purge_batch_size is a performance enhancement, Should also be used in 5.5 to reduce purge overhead. innodb_open_files is now dynamic at startup, based on the table_open_cache setting because we expect most tables to be InnoDB and use innodb_file_per…
