List:General Discussion« Previous MessageNext Message »
From:Don O'Neil Date:April 12 2007 8:17pm
Subject:Mysql Hogging all system resources
View as plain text  
I have a customer that loaded up a HUGE table and was doing all sorts of
fancy stuff in it, and not waiting for the process to finish before sending
the same query, and eventually loading up the server to the point where the
only thing I could do was unplug it.

Is there a way to prioritize or set the amount of resources that MySQL is
allowed to have? Do I need to set it up as a jailed process maybe? I've
never done that before, so I'm not sure if it's the right approach or not.

I'm running FreeBSD 6.1.

Thread
Mysql Hogging all system resourcesDon O'Neil12 Apr
  • Re: Mysql Hogging all system resourcesChuck Swiger13 Apr
    • RE: Mysql Hogging all system resourcesDon O'Neil13 Apr
      • RE: Mysql Hogging all system resourcesDon O'Neil13 Apr
        • Re: Mysql Hogging all system resourcesDan Nelson13 Apr
          • RE: Mysql Hogging all system resourcesDon O'Neil14 Apr
      • Re: Mysql Hogging all system resourcesChuck Swiger13 Apr
        • RE: Mysql Hogging all system resourcesAndrey Dmitriev13 Apr