Results 1 to 7 of 7

Thread: mysql uses 100% of my processing power

Threaded View

  1. #1
    Join Date
    May 2006
    Location
    The Netherlands
    Posts
    3
    Rep Power
    9

    Default mysql uses 100% of my processing power

    on my zimbra system (debian using the latest 3.1.0 zimbra version, amd opteron 2 GHz, dedicated for zimbra) with currently just around 10 mailboxes and a throughput of a few hundred email messages per day, mysql uses 100% of my processing power.

    i find this odd.

    how can I check what mysql is doing?

    zimbra@zimbra:~/db/data$ ~/mysql/bin/mysqladmin -P 7306 -S /opt/zimbra/db/mysql.sock status
    Uptime: 3564 Threads: 3 Questions: 3167 Slow queries: 8 Opens: 21 Flush tables: 1 Open tables: 15 Queries per second avg: 0.889

    top - 13:40:45 up 39 days, 19:00, 2 users, load average: 0.80, 0.77, 0.87
    Tasks: 106 total, 2 running, 104 sleeping, 0 stopped, 0 zombie
    Cpu(s): 65.4% us, 34.6% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
    Mem: 2077192k total, 2005096k used, 72096k free, 179124k buffers
    Swap: 3903752k total, 64k used, 3903688k free, 1119872k cached

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    5024 zimbra 16 0 92208 21m 3108 S 99.8 1.1 46:54.16 mysqld
    9121 gerbrand 16 0 6520 1564 1072 R 0.3 0.1 0:00.22 sshd
    1 root 16 0 1604 532 468 S 0.0 0.0 0:07.46 init
    CPU usage since mailboxes start receiving email




    Last edited by Gerbrand; 05-06-2006 at 05:49 AM.

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  2. Zimbra wont start, only LDAP...
    By redbaron in forum Installation
    Replies: 14
    Last Post: 08-11-2007, 12:17 AM
  3. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  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
  •