List:General Discussion« Previous MessageNext Message »
From:J M Date:May 31 2012 4:26pm
Subject:Mysql starts to die at 27 SQL processes
View as plain text  
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,
Thread
Mysql starts to die at 27 SQL processesJ M31 May
  • Re: Mysql starts to die at 27 SQL processesBaron Schwartz31 May
    • Re: Mysql starts to die at 27 SQL processesJ M31 May
      • RE: Mysql starts to die at 27 SQL processesRick James31 May
  • Re: Mysql starts to die at 27 SQL processesAndrĂ©s Tello31 May