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