…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 …it looks like innodb_open_files_limit=300 is not being that large liability even with large number of tables and you can also…
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…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…_used_connections’, ’651′ ‘Not_flushed_delayed_rows’, ’0′ ‘Open_files‘, ’95′ ‘Open_streams’, ’0′ ‘Open_tables‘, ’512′ ‘Opened_tables‘, ’183240′ ‘Qcache_free_blocks’, ’136′ ‘Qcache_free_memory…-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout… used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used before…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…_buffer_size = 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 = 100M read_buffer… are using BDB tables #bdb_cache_size = 384M #bdb_max_lock = 100000 # Uncomment the following if you are using InnoDB tables #innodb_data…
Comment: How innodb_open_files affects performance
April 14, 2010 By 4 Comments
…/16/table_cache-negative-scalability/ asking about open_file_limit. One thing I see that is not talked about is how the os ulimit of “open files“, mysql setting “open_file_limit” affects the OS/MySQL and I believe is non-biased to MyISAM and InnoDB table types. If the max open_file_limit…
Comment: Why MySQL could be slow with large tables ?
June 21, 2006 By 139 Comments
…out of file descriptors. “table_cache” is what defines how many tables will be opened and you can configure it independently of number of tables you… all tables kept open permanently which can waste a lot of memory but it is other problem. Speaking about “open_file_limit” which limits number of files…
Post: Limiting InnoDB Data Dictionary
February 11, 2009 By 13 Comments
…after table was once opened. Only way to cleanup memory is to drop table or restart…there http://mysqlperformanceblog.com/files/patches/innodb_dict_size_limit_standalone.patch. Currently …table_cache, memory consumed by data dictionary may exceed innodb_dict_size_limit, as we can’t delete any table…
Comment: More on table_cache
September 7, 2010 By 7 Comments
@Jay Pipes, I agree with you its only a MyISAM specific issue for the most part. Another reason for using a smaller table_cache http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/mysql_tablecache_informationschema_and_open_files_limit.php
