Results 1 to 3 of 3

Thread: MySQL CPU Usage

  1. #1
    Join Date
    Nov 2005
    Posts
    63
    Rep Power
    10

    Post MySQL CPU Usage

    This problem started occurring sometime while I had 4.0.2 and was not corrected by upgrading to 4.0.5. The host OS is CentOS 4.3 running 2.6.9-42.0.3.

    The problem is that the MySQL predominantly uses all available CPU resources, resulting in a server load level of 2.5+ even when all else is quiet. I've not been able to find anything conclusive on the forums or wiki. The mysqld.slow log is huge, with a wide variety of queries included. It is acting almost as though it has lost its indexes and is having to do scan lookups for every action.

    Any suggestions would be greatly welcomed.

    Thanks,
    Will

  2. #2
    Join Date
    Sep 2005
    Posts
    78
    Rep Power
    10

    Default

    Which MySQL instance is the problematic one, the one used by the mailbox server or by logger? You can find out by running ps -ef and grepping for the process id in question. If it's logger, try disabling the logger task in the zimbra user's crontab.

  3. #3
    Join Date
    Nov 2005
    Posts
    518
    Rep Power
    11

    Default

    Comment out this line to prevent the log processing that populates the logger db:
    Code:
    crontab -l | grep logproc
    00,10,20,30,40,50 * * * * /opt/zimbra/libexec/zmlogprocess > /tmp/logprocess.out 2>&1
    To completely disable the logger service:
    Code:
    zmprov ms `zmhostname ` -- -zimbraServiceEnabled logger
    zmloggerctl stop

Similar Threads

  1. High CPU usage on server and client
    By jack-Z in forum Administrators
    Replies: 10
    Last Post: 01-07-2009, 10:12 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  3. Mysql CPU load
    By Rajesh Yadav in forum Users
    Replies: 4
    Last Post: 05-14-2006, 05:23 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, 07: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
  •