[TriLUG] MySQL Runaway

[Boggs, Ted]

Have you checked the slow query log (assuming you log slow queries)?

Have you looked at the process list in MySQL to see what queries are
running at the time (show processlist;)?


--
Ted Boggs



On Wed, May 8, 2013 at 12:02 AM, Brian McCullough <bdmc at buadh-brath.com>wrote:

> Folks,
>
> I am having occasional issues with a web site that is running against a
> MySQL database.
>
> When this issue occurs, Top shows the mysqld process at around 800% CPU
> load, and the overall system load goes through the roof, too.
>
> The system has 8 Gig of physical RAM, 4 Gig of Swap, so my first
> response was to change the my.cnf from the default copy to the "huge"
> example.
>
> This seemed to help a bit, but we still get these storms, and I have no
> idea of how to diagnose what is going on and how to prevent it.
>
> "I am not a DBA, I just play one on TV."
>
>
> I inherited this system, like a lot of the work that I do, so I suspect
> that I am attacking a long-standing issue, and we are only really seeing
> it because we are now monitoring the system more carefully.
>
>
> AdvTHANKSance,
> Brian
>
>
> --
> This message was sent to: Ted Boggs <tboggs at mcclatchyinteractive.com>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that
> address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web  :
> http://www.trilug.org/mailman/options/trilug/tboggs%40mcclatchyinteractive.com
> TriLUG FAQ          :
> http://www.trilug.org/wiki/Frequently_Asked_Questions
>