… about the same, taking 1sec (on the second time) . Whenever innodb_open_files_limit was 64 (virtually all misses ) or 16384 (all hits) performance… test with innodb_open_files=16384 I got about same crash recovery speed though with no warnings. So it looks like innodb_open_files_limit=300 is…
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…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… open_files_limit set to 40000? 2) Could you explain the difference between MyISAM and InnoDB and the difference in how the OS handles opened files… 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
… becuase I have the open_files_limit set to 40000? 2) Could you explain the difference between MyISAM and InnoDB table cache? 3) Would… 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: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout… MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb…
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… discovered that InnoDB will still create the status file on disk even if you do not specify innodb-status-file option. The file is actually…-closed files (file is physically removed only after it is no longer open by any process). First be sure to run SHOW ENGINE InnoDB…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…Innodb kernel and still has 400 tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads to run inside Innodb…however can be adjusted by innodb_file_io_threads variable. For…0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main…
Comment: How innodb_open_files affects performance
April 14, 2010 By 4 Comments
… “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 is 65535, does this mean a linux 64bit server could never have more than that opened…
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…_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb…
Post: What is the longest part of Innodb Recovery Process ?
December 20, 2007 By 2 Comments
…not keep server completely unusable (some limitations still apply though). In the …innodb_file_per_table so “InnoDB: Reading tablespace information from the .ibd files…” stage was taking most of the time. Happily Innodb… – “Opening Tables”. As Innodb has to recompute the stats first time it opens …
