… there will be a huge waste of space. I used MySQL 5.4.2 for tests which should be as good as… the same, taking 1sec (on the second time) . Whenever innodb_open_files_limit was 64 (virtually all misses ) or 16384 (all hits) performance… 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: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…MySQL won’t revert to opening the FRM files to read the table definition, but we can see from strace: [pid 19876] open… MySQL 5.5 you can find in sql/datadict.cc a function named dd_frm_type(). In MySQL 5… can ignore the upper limit on number of storage engines for MySQL and understanding the …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…-running transaction. If a transaction remains open for a very long time without…log, and examine the log. In MySQL 5.1 and newer with the InnoDB…p on b.trx_mysql_thread_id = p.ID LIMIT 1′) if [ "${host}" ]; then echo…no-report –print” on the resulting tcpdump file (after inspecting the captured SHOW …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… MySQL 5.5.16, including all the bug fixes in it, Percona Server 5.5.16-22.0 is now the current stable release in the 5.5 series. All of Percona’s software is open…for production environments. This feature limits the age of idle |XtraDB| …, restoring from the LRU dump file is synchronous, i.e. …
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…on MySQL 5.1.59, including all the bug fixes in it, Percona Server 5.1…in the 5.1 series. All of Percona’s software is open-source and … suited for production environments. This feature limits the age of idle |XtraDB| transactions…. ON, restoring from the LRU dump file is synchronous, i.e. InnoDB waits…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…some cases): vmstat 5 5 iostat -dx 5 5 If you don…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… output. The stock MySQL server’s limitation of one-second… knowing openings in chess — the great chess players study openings …
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… Swap: 4194224k av, 553604k used, 3640620k free 3352196k cached #iostat 5 2 avg-cpu: %user %nice %sys %iowait %idle 20.49…=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…: Too many open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc…27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set …open tables issue? Thanks for your help! Server info: Server version: 5.0.79-enterprise-log MySQL …
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…: Too many open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc…27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set …open tables issue? Thanks for your help! Server info: Server version: 5.0.79-enterprise-log MySQL …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…enough memory allocated to get to address space limit and MySQL will crash when one of internal …your MySQL server to run out of file descriptors. The same is true for Partitioned tables in MySQL 5…. are implemented as temporary tables, so by opening large amount of cursors which are handled …
