Hi Rick Thank you for replying.
Please see my answers to your questions. On Tue, Mar 27, 2012 at 7:58 PM, Rick James <rja...@yahoo-inc.com> wrote: > Do you have 12GB of RAM? total used free shared buffers cached Mem: 12038 11959 78 0 139 11234 -/+ buffers/cache: 586 11451 Swap: 2047 0 2047 > Is this a 64-bit mysqld? Linux hostname 2.6.32-5-amd64 #1 SMP Mon Jan 16 16:22:28 UTC 2012 x86_64 GNU/Linux > Let's see > SHOW VARIABLES LIKE '%buffer%'; +-------------------------+---------+ | Variable_name | Value | +-------------------------+---------+ | bulk_insert_buffer_size | 8388608 | | innodb_buffer_pool_size | 8388608 | | innodb_log_buffer_size | 1048576 | | join_buffer_size | 131072 | | key_buffer_size | 8384512 | | myisam_sort_buffer_size | 8388608 | | net_buffer_length | 16384 | | preload_buffer_size | 32768 | | read_buffer_size | 131072 | | read_rnd_buffer_size | 262144 | | sort_buffer_size | 2097144 | | sql_buffer_result | OFF | +-------------------------+---------+ > SHOW GLOBAL STATUS LIKE 'Max%'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | Max_used_connections | 3 | +----------------------+-------+ > SHOW GLOBAL STATUS LIKE 'Up%'; +---------------------------+-------+ | Variable_name | Value | +---------------------------+-------+ | Uptime | 18492 | | Uptime_since_flush_status | 18492 | +---------------------------+-------+ > What is Apache's MaxClients? MaxClients 1000 Thank you again. Brent > > > On 3/27/12 6:25 AM, Brent Clark wrote: >> >> Good day KarthiK.P.R >> >> Other than the replication settings in '/etc/mysql/conf.d/replication.cnf' >> and our /etc/mysql/conf.d/custom.cnf >> >> xyz-web02:/data# cat /etc/mysql/conf.d/custom.cnf >> [mysqld] >> innodb_file_per_table >> bind-address = 0.0.0.0 >> datadir = /data >> binlog_format=mixed >> key_buffer_size=8384512 >> max_connections=41 >> >> The original /etc/mysql/my.cnf is untouched. >> >> The only other service we have running is DRBD (active / active) and >> apache, nothing is hitting apache as this is the standby node. >> And there is no load, or anything consuming resources. >> >> Thanks >> Brent >> >> >> On 27/03/2012 14:04, P.R.Karthik wrote: >>> >>> HI Brent, >>> >>> Can you please paste your configuration file settings (my.cnf) ? It will >>> help to identify where things went wrong. >>> >>> Is there any other memory consuming application running on the server >>> beyond mysql ? >>> >>> Regards, >>> KarthiK.P.R >>> >>> >>> >>> On Tue, Mar 27, 2012 at 4:17 PM, Brent >>> Clark<brentgclarkl...@gmail.com<mailto:brentgclarkl...@gmail.com>> wrote: >>> >>> Hey Guys >>> >>> Yesterday I sent an email, about '1 client is using or hasn't closed >>> the table properly', but the problem is actually bigger than I realised. >>> >>> We run Mysql replication, and on the second node, Mysql is crashing >>> with 'mysqld got signal 6' every so often. >>> >>> Other than the drives, we have replaced the hardware, and still the >>> problem persists. >>> >>> Googling, I thought it was a memory exhaustion issue, so I started >>> playing with the following variables and values. >>> >>> key_buffer_size=8384512 >>> max_connections=41 >>> >>> But it still crashes >>> >>> Mar 27 12:36:53 xyz-web02 mysqld: key_buffer_size=8384512 >>> Mar 27 12:36:53 xyz-web02 mysqld: read_buffer_size=131072 >>> Mar 27 12:36:53 xyz-web02 mysqld: max_used_connections=3 >>> Mar 27 12:36:53 xyz-web02 mysqld: max_threads=41 >>> Mar 27 12:36:53 xyz-web02 mysqld: thread_count=1 >>> Mar 27 12:36:53 xyz-web02 mysqld: connection_count=1 >>> Mar 27 12:36:53 xyz-web02 mysqld: It is possible that mysqld could >>> use up to >>> Mar 27 12:36:53 xyz-web02 mysqld: key_buffer_size + (read_buffer_size >>> + sort_buffer_size)*max_threads = 97828 K bytes of memory >>> >>> xyz-web02:# free -m >>> total used free shared buffers >>> cached >>> Mem: 12038 11966 71 0 117 >>> 11378 >>> -/+ buffers/cache: 469 11568 >>> Swap: 2047 0 2047 >>> >>> We running Debian Squeeze 64bit. >>> >>> I have attached the full crash message. >>> >>> If anyone can help, I would be *most* grateful (If you are in South >>> Africa, I will buy you a meal, let alone a beer :) >>> >>> Kindest Regards >>> Brent Clark >>> >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: http://lists.mysql.com/mysql >>> >>> >> > > -- > Rick James - MySQL Geek > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql