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.

Server Dies Coz of Mysql

Discussion in 'General Discussion' started by yashodeep, Aug 6, 2004.

  1. yashodeep

    yashodeep Member

    Joined:
    Dec 3, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    maharashtra
    Hello All...

    I have my 2 servers, on one i have my site and on another i have my database. The server on which the database is there is in danger because of mysql, the load is extremely high at the times and mysql always taking 99.9 % CPU resources. :confused:

    I have already had a look at my database,queries and its optimization but haven't got any possitibve result so far. :mad:

    So anybody ? able to help me, so that i can get some good sleep !!

    Standing at the doorsteps to take your suggetions.......


    Yash
     
  2. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
    make sure the database tables are indexed so the mysql does not have to search every record each query
     
  3. yashodeep

    yashodeep Member

    Joined:
    Dec 3, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    maharashtra
    Hey Thanks for the suggestion... I have already did that.
     
  4. mr.wonderful

    mr.wonderful BANNED

    Joined:
    Feb 1, 2004
    Messages:
    345
    Likes Received:
    0
    Trophy Points:
    0
    Server Dies Coz of Mysql?

    What is Coz of? Where did you learn to spell? Prison?
     
  5. yashodeep

    yashodeep Member

    Joined:
    Dec 3, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    maharashtra
    Ok.. May be spelled wrong.. but i guess rather than correct spellings, the issue and solutions would help me a lot.. Thanks.
     
Loading...

Share This Page