… to keep open file descriptor when table is open – open table is purely logical state and appropriate .ibd file may be open or closed. Furthermore besides MySQL table_cache Innodb maintains… previous experiments I was running with table_open_cache=64 and tried innodb_open_files=64 and 16384. Reading 100.000 tables first time after MySQL time…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…table_cache (or table_open_cache_ values indeed can cause significant performance problems. Interesting enough Innodb has a very similar task of managing its own cache of file descriptors (set by innodb_open_files) …
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… InnoDB table cache? 3) Would converting the MyISAM tables to InnoDB fix or help the os ulimit max open tables…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
…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: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort_buffer_size = … using InnoDB tables #innodb_data_home_dir = /usr/local/mysql/data/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_…
Comment: MySQL File System Fragmentation Benchmarks
March 23, 2008 By 28 Comments
Kevin, table_cache is not the only one you should be looking for – if you’re using innodb_file_per_table setting innodb_open_files also need to be set high enough so no reopens are required. I specially kept those default so we get the open/reopen overhead factored in.
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Open_filesblogpercona.commanual open_files_limitblogpercona.commanual Open_streamsblogpercona.commanual Open_table_definitionsblogpercona.commanual Open_tablesblogpercona.commanual Opened_filesblogpercona.commanual Opened_table_definitionsblogpercona.commanual Opened…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-import-table-from-xtrabackup=1 innodb-io-capacity=1000 innodb-log-buffer-size=32M innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…in the server: DROP TABLE RENAME TABLE DROP VIEW open table filling INFORMATION_SCHEMA tables (I think it is actually the TABLES table, but didn’t …has cached (often at least twice – in InnoDB itself and in the table_definition_cache). Further reading: MySQL Forge Internals document on the FRM file…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… as its file cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O… day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-… in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987,…
