…)# cat /proc/`pidof mysqld`/limits | egrep “(processes|files)” Max processes 22888 22888 processes Max open files 6000 6000 files But let’s say that a new…)# cat /proc/`pidof mysqld`/limits | egrep “(processes|files)” Max processes 1024 unlimited processes Max open files 4206 4206 files Now, once this server hits 1024 simultaneous…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… how the OS handles opened files? 3) Would converting the MyISAM tables to InnoDB fix or help the os ulimit max open tables issue? Thanks… = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… the MyISAM tables to InnoDB fix or help the os ulimit max open tables issue? Thanks for your help! Server info: Server version… = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table…
Comment: How innodb_open_files affects performance
April 14, 2010 By 4 Comments
…/ asking 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 65535, does this mean a linux 64bit server could never have more than that opened at a…
