… – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does not have to keep open file descriptor… running with table_open_cache=64 and tried innodb_open_files=64 and 16384. Reading 100.000 tables first time after MySQL time takes about…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…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…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…| +————+ | Compact | +————+ ~/recovery-tool# ./page_parser -5 -f data/salaries.ibd Opening file: data/salaries.ibd: [...] 71.43% done. 2012-02-14 … IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id …
Post: Rare evil MySQL Bug
November 20, 2009 By 7 Comments
… funny state. When you see bug happening you would see MySQL log flooded with error messages like this: 091119 23:03… in production so we had to restart MySQL quickly currently I have a test MySQL showing some behavior. Here is what strace… accept gets pretty high socket number – probably because of large innodb_open_files I tested with in this case – which all can be…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…in accept: Too many open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc_miehr…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…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…in accept: Too many open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc_miehr…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: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…data permanently. The pmp-check-mysql-deleted-files plugin will alert when files have been deleted but remain open via a filehandle. Wrong filesystem…times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB is getting stuck, has…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… keep within just a MySQL server. The first step is to log into the machine via SSH and open up a text… the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file. But again…. You might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… limited MySQL command output. First one is that you can have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status.
