List:General Discussion« Previous MessageNext Message »
From:P.R.Karthik Date:March 27 2012 12:04pm
Subject:Re: mysqld got signal 6 (problem why bigger than I initially realised)
View as plain text  
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 <brentgclarklist@stripped>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
>

Thread
mysqld got signal 6 (problem why bigger than I initially realised)Brent Clark27 Mar
  • Re: mysqld got signal 6 (problem why bigger than I initially realised)P.R.Karthik27 Mar
    • Re: mysqld got signal 6 (problem why bigger than I initially realised)Brent Clark27 Mar
      • Re: mysqld got signal 6 (problem why bigger than I initially realised)Rick James27 Mar
        • Re: mysqld got signal 6 (problem why bigger than I initially realised)Brent Clark27 Mar
          • Re: mysqld got signal 6 (problem why bigger than I initially realised)Rick James27 Mar
            • Re: mysqld got signal 6 (problem why bigger than I initially realised)Reindl Harald28 Mar
              • Re: mysqld got signal 6 (problem why bigger than I initially realised)Rick James29 Mar
                • Re: mysqld got signal 6 (problem why bigger than I initially realised)Reindl Harald29 Mar