Results 1 to 4 of 4

Thread: Upgraded to 4.5.11; mysqld Now Consuming 99.9% CPU

  1. #1
    LMStone's Avatar
    LMStone is offline Moderator
    Join Date
    Sep 2006
    Location
    477 Congress Street | Portland, ME 04101
    Posts
    1,374
    Rep Power
    10

    Default Upgraded to 4.5.11; mysqld Now Consuming 99.9% CPU

    Hi,

    We upgraded our SuSE ES9 32-bit NE installation from 4.5.6 to 4.5.11 and have noticed that the mysqld process is now frequently consuming 99.9% of CPU as reported by top.

    Our hardware has 6GB of RAM and Zimbra support previously set the memory allocation for Tomcat and MySQL to 20% back when we were running 4.0.3.

    Now that we are at 4.5.11 I am wondering if some tweaking is called for. This particular server hardware is an HP DL360 G4p with 2 x 3.00GHz 2MB CPUs and 2 x 146GB 15K disks in a RAID1 array.

    I noticed in the my.cnf file that since the upgrade the last line declaring the pid file is listed twice. I also attach yesterdays MySQL slow log file.

    Any tips would be greatly appreciated!

    Thanks!
    Mark
    Attached Files Attached Files

  2. #2
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    can you grab the /opt/zimbra/log/zmmailboxd.out from the same time? Also, a crontabl -l -u zimbra would help.

  3. #3
    bobby is offline Zimbra Employee
    Join Date
    Nov 2005
    Posts
    518
    Rep Power
    10

    Default

    Is it the mailbox mysqld or the logger mysqld that is consuming the cpu?

  4. #4
    LMStone's Avatar
    LMStone is offline Moderator
    Join Date
    Sep 2006
    Location
    477 Congress Street | Portland, ME 04101
    Posts
    1,374
    Rep Power
    10

    Default

    Quote Originally Posted by jholder View Post
    can you grab the /opt/zimbra/log/zmmailboxd.out from the same time? Also, a crontabl -l -u zimbra would help.
    Hi John,

    Thanks for the reply.

    There is no zmmailboxd.out:
    zimbra@viognier:~> locate *.out
    /etc/postfix.suse/makedefs.out
    /opt/zimbra/apache-tomcat-5.5.15/logs/catalina.out
    /opt/zimbra/log/convertd.out
    /opt/zimbra/log/zmlogswatch.out
    /opt/zimbra/postfix-2.2.9/conf/makedefs.out
    /opt/zimbra/zmstat/zmstat.out

    Attached though is the output from ps -ef | grep zimbra while the mysqld was pegged, along with the crontab you asked for.

    All the best,
    Mark
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. mysqld hogging all the cpu
    By jeffw in forum Administrators
    Replies: 7
    Last Post: 01-16-2008, 07:50 PM
  2. Upgrade 4.5.1 -> 4.5.2 Network Edition on RH Failed
    By CJ.deb in forum Installation
    Replies: 7
    Last Post: 03-01-2007, 07:05 AM
  3. 3.1 on FC4 problems
    By cohnhead in forum Installation
    Replies: 8
    Last Post: 05-26-2006, 11:16 AM
  4. System-Load with M4
    By billybofh in forum Administrators
    Replies: 7
    Last Post: 02-15-2006, 02:11 AM
  5. Installation on FC3 under Xen
    By andreground in forum Installation
    Replies: 9
    Last Post: 11-14-2005, 10:29 AM

Posting Permissions

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