… that MySQL won’t revert to opening the FRM files to read the table definition, but we can see from strace: [pid 19876] open… it is. We can ignore the upper limit on number of storage engines for MySQL and understanding the relationship between the range…_cache). Further reading: MySQL Forge Internals document on the FRM file format Stewart’s blog post on the FRM file format (from early…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… to work with many customers having large number of connections opened in MySQL and although I told them this was not optimal… an influence, because those idle threads are presents in internal MySQL list objects that need to be scanned and also the… innodb_flush_log_at_trx_commit=0 max_connections = 10000 open_files_limit = 32768 The desktop is running Ubuntu 10.04, has 8GB…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…max_heap_table_size=128M event_scheduler=ON query_cache_limit = 10M open_files_limit = 8088 back_log=128 max_allowed_packet = 50M # …= 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> …
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 10 Comments
… mysqld`/limits | egrep “(processes|files)” Max processes 22888 22888 processes Max open files 6000 6000 files But let’s say that a new version of MySQL… MySQL (Percona Server).. SUCCESS! [~] (root@revolution 23:59:45)# cat /proc/`pidof mysqld`/limits | egrep “(processes|files)” Max processes 1024 unlimited processes Max open files…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… query log output. The stock MySQL server’s limitation of one-second granularity makes…’s like knowing openings in chess — the great chess players study openings exhaustively, but…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…] Error in accept: Too many open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc_miehr_posasmp/panel…, 31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set to 40000? 2… 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
…] Error in accept: Too many open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file: ‘./wc_miehr_posasmp/panel…, 31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set to 40000? 2… thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
Comment: How innodb_open_files affects performance
April 14, 2010 By 4 Comments
… 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 is…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 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…=/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: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…/mysql.sock bind-address=10.234.94.71 skip-locking key_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…
