Don't you have any message? For the number of max connections, I suppose you are hitting the limit of file opened, there are no messages at error log?
Check this: http://www.geeksww.com/tutorials/database_management_systems/mysql/configuration/mysql_open_files_limit_openfileslimit_vs_openfileslimit_on_linux.php and maybe you need to set files to ulimit... Which distribution and kernel would be usable... uname -a to get kernel information On Thu, May 31, 2012 at 11:26 AM, J M <jerom...@gmail.com> wrote: > hi all, > > i have an issue with our db which hangs and the only way to > recover from it is to restart mysql if you had console access or > restart the box itself ( only if i can't wait ) > > show processlist result can be found here: > http://pastebin.com/BYvZ5ZFR > > listed below are info about the setup: > > ====================================== > * Master-slave config... > ====================================== > * config.. > > [client] > port = 3306 > socket = /var/lib/mysql/mysql.sock > > > [mysqld] > port = 3306 > socket = /var/lib/mysql/mysql.sock > skip-locking > key_buffer_size = 256M > max_allowed_packet = 1M > sort_buffer_size = 2M > > read_buffer_size = 256K > read_rnd_buffer_size = 256K > > # Testing Config > #log = /tmp/sql.log > # Testing Config End > > myisam_max_sort_file_size = 2G > myisam_sort_buffer_size = 64M > thread_cache_size = 8 > > # Change 20110825 10:30AM > query_cache_size = 256M > > query_cache_limit = 1M > thread_concurrency = 8 > max_connections = 600 > wait_timeout = 10 > interactive_timeout = 300 > > table_open_cache = 750 > table_definition_cache=750 > > # Change 20110825 10:30AM > #max_heap_table_size = 64M > #tmp_table_size = 64M > max_heap_table_size = 256M > tmp_table_size = 256M > > > #max_write_lock_count = 1 > #low_priority_updates = 1 > > #skip-networking > > log-bin=mysql-bin > server-id = 1 > binlog-ignore-db = mysql > expire_logs_days = 7 > > skip-innodb > > [mysqldump] > quick > max_allowed_packet = 16M > > [mysql] > no-auto-rehash > > [myisamchk] > key_buffer_size = 256M > sort_buffer_size = 256M > read_buffer = 2M > write_buffer = 2M > > [mysqlhotcopy] > interactive-timeout > > ====================================== > > use: website > > ====================================== > > I have a decent amount of resources: > > total used free shared buffers cached > Mem: 16425876 6883564 9542312 0 3378468 2384308 > -/+ buffers/cache: 1120788 15305088 > Swap: 6144852 208 6144644 > > > 16 core server ( DB is dedicated ) > > ====================================== > > DB: v5.1.x > > > ====================================== > > Storage: local disk @ Raid 10 > > Notes: > > assuming that application alteration is limited.. so i want to push > the DB as far as it can go.. > > since i have 16G approximately @ current config i take 3G @600 > though the highest connection i get is 230 connection. > > tia, > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
