Find the answer to your Linux question:
Results 1 to 2 of 2
Hello, I use two dedicate server to host my website, the apache servcies running on one server and mysqld running on another. Now the the server running mysqld is slowly, ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Apr 2012
    Posts
    6

    The CPU load of my Database server is high


    Hello,

    I use two dedicate server to host my website, the apache servcies running on one server and mysqld running on another.
    Now the the server running mysqld is slowly, i found the cpu load reached to 11, normally it should around 6. It also lead to i can't open my website, so i restart mysqld, using the command service mysqld restart. then the server and the website are back to normal.

    Now can somebody tell me what shall i do to get the reason leading to the website can't open?
    what steps should i do?


    Levi

  2. #2
    Just Joined!
    Join Date
    Aug 2002
    Location
    Laguna Salada
    Posts
    12
    Quote Originally Posted by jistso View Post
    Hello,

    I use two dedicate server to host my website, the apache servcies running on one server and mysqld running on another.
    Now the the server running mysqld is slowly, i found the cpu load reached to 11, normally it should around 6. It also lead to i can't open my website, so i restart mysqld, using the command service mysqld restart. then the server and the website are back to normal.

    Now can somebody tell me what shall i do to get the reason leading to the website can't open?
    what steps should i do?


    Levi
    Have u test your queries?
    Do they have the right indexes?
    How are your I/0 in both servers?
    How u open mysql log queries?
    Does apache log say something?

    U have much work to do!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •