…: mysql soft nproc 4096 followed up by a restart of MySQL in a fresh user session. If you’re running RHEL/CentOS 5… 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…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…open files 100414 0:21:52 [ERROR] /usr/local/mysql/bin/mysqld: Can’t open file…file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit…opened files? 3) Would converting the MyISAM tables to InnoDB fix or help the os ulimit max open…
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… help the os ulimit max open tables issue? Thanks for your help! Server info: Server version: 5.0.79-enterprise-log MySQL Enterprise Server… thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
