List:General Discussion« Previous MessageNext Message »
From:Andrés Tello Date:May 31 2012 6:54pm
Subject:Re: Mysql starts to die at 27 SQL processes
View as plain text  
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
>
>

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