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 <jerome.m@stripped> 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
>
>
