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
