… the same, taking 1sec (on the second time) . Whenever innodb_open_files_limit was 64 (virtually all misses ) or 16384 (all hits) performance…_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too many (68) files stay open while… 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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…here — we focus on far more than my.cnf files. In fact my.cnf files are usually one of the smallest …query log output. The stock MySQL server’s limitation of one-second granularity makes it hide …. It’s like knowing openings in chess — the great chess players study openings exhaustively, but they …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in… = 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…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…, 31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set to 40000? 2… max open tables issue? Thanks for your help! Server info: Server version: 5.0.79-enterprise-log MySQL Enterprise Server (Commercial) my.cnf… thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…, 31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set to 40000? 2… max open tables issue? Thanks for your help! Server info: Server version: 5.0.79-enterprise-log MySQL Enterprise Server (Commercial) my.cnf… thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
Comment: What to tune in MySQL Server after installation
March 10, 2007 By 116 Comments
MySQL – Standardkonfiguration (InnoDB)… Server Open File Limit > 10000 coredumps müssen funktionieren /etc/my.cnf Gute Referenz:…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… to the limited MySQL command output. First one is that you can have innodb-status-file option set in your my.cnf. This will… access deleted but not-yet-closed files (file is physically removed only after it is no longer open by any process). First be… 11886 ? Ssl 0:01 /usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my case the process ID is 11886, so I will…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…you have it all in place, we can begin. Open command line (shell) on the server and go … it in my.cnf file, the remaining part of the configuration will not matter, because the log file won’t … SESSION and SET GLOBAL. log_slow_rate_limit=# Rate limit statement writes to slow log to only those …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…file cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf…: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement,…going on to quantify what are the limits of different operations for different levels of…
