The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' 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:
    6
    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:
    6
  3. netlook

    netlook Well-Known Member
    PartnerNOC

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

    Miss Jacky Well-Known Member

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

Share This Page