Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

cpu/mem usage too high with big sql query (creating DB)

Discussion in 'Database Discussion' started by Miss Jacky, May 4, 2004.

  1. Miss Jacky

    Miss Jacky Well-Known Member

    Joined:
    Mar 4, 2004
    Messages:
    91
    Likes Received:
    0
    Trophy Points:
    156
    Hi,

    It seems that, on our server, when someone does a large sql query in phpmyadmin, putting a mysql dump in a new DB, I see this proces in top:

    [​IMG]

    As you can see it uses a *lot* of the available memory and the result is that the server slows down heavily. Are there any ways to overcome this? Restricted the memory usage for phpmyadmin? I don't have a clue... any help greatly appreciated.

    If you see any vars in that screenshot which aren't really good... you may also comment. :)
     
  2. Miss Jacky

    Miss Jacky Well-Known Member

    Joined:
    Mar 4, 2004
    Messages:
    91
    Likes Received:
    0
    Trophy Points:
    156
  3. netlook

    netlook Well-Known Member
    PartnerNOC

    Joined:
    Mar 25, 2004
    Messages:
    335
    Likes Received:
    0
    Trophy Points:
    166
    Any idea?
     
  4. Miss Jacky

    Miss Jacky Well-Known Member

    Joined:
    Mar 4, 2004
    Messages:
    91
    Likes Received:
    0
    Trophy Points:
    156
    Are you having the same problem?
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice