Results 1 to 5 of 5

Thread: Mysql CPU load

  1. #1
    Rajesh Yadav is offline Starter Member
    Join Date
    May 2006
    Posts
    2
    Rep Power
    9

    Question Mysql CPU load

    Hello everybody,

    I am using zimbra opensource on FC4. mysql is always showing 99% cpu usage
    Pls suggest whats wron ?

  2. #2
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    Check the myslow logs in the log directory. How much memory do you have?
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  3. #3
    JoshuaPrismon is online now Zimlet Guru & Moderator
    Join Date
    Nov 2005
    Posts
    477
    Rep Power
    9

    Default

    Quote Originally Posted by Rajesh Yadav
    Hello everybody,

    I am using zimbra opensource on FC4. mysql is always showing 99% cpu usage
    Pls suggest whats wron ?
    Are you using DSPAM? I have noticed that the CPU load can spike significantly if you use DSPAM and Mysql according to the old directions...

  4. #4
    Rajesh Yadav is offline Starter Member
    Join Date
    May 2006
    Posts
    2
    Rep Power
    9

    Default Mysql CPU load

    Quote Originally Posted by KevinH
    Check the myslow logs in the log directory. How much memory do you have?
    i have 1GB ECC MEM, the size of my logger_myslow.log is 2gb. I deleted the same and again its grown upto 19Mb since last 2 days.

  5. #5
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    Quote Originally Posted by Rajesh Yadav
    i have 1GB ECC MEM, the size of my logger_myslow.log is 2gb. I deleted the same and again its grown upto 19Mb since last 2 days.
    You could disable the logger cron tasks. This should stop the CPU usage but won't allow you to query the logs.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. MySQL CPU Usage
    By wdimmit in forum Administrators
    Replies: 2
    Last Post: 01-08-2007, 02:21 PM
  3. CPU Load
    By claros in forum Administrators
    Replies: 1
    Last Post: 08-11-2006, 06:56 PM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

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