Results 1 to 3 of 3

Thread: mysqld is at 99%

  1. #1
    Join Date
    Sep 2005
    Location
    Calgary
    Posts
    208
    Rep Power
    10

    Default mysqld is at 99%

    Hello all i have been running version 6.0.0.1 now for about a month everything was going ok until yesterday. For some reason each time i try to access my mail though the web i get an error about the server taking to long to respond.

    Quick check of top is telling me that mysqld owned by zimbra is at 99% it goes away for a bit, but as soon i check my email again i shoot back up to 99% and stays there for way to long making the web interface unresponsive.

    I do not seem to see anything that corresponds in the zimbra.log or the mysql_error.log but have posted a tail of the latter anyhow

    091001 22:43:24 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

    091001 22:43:24 mysqld ended

    091001 22:48:14 mysqld started
    091001 22:48:14 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    091001 22:48:14 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    091001 22:48:16 InnoDB: Started; log sequence number 0 1884987325
    091001 22:48:16 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.83-log' socket: '/opt/zimbra/db/mysql.sock' port: 7306 Source distribution

    Sorry if this has been posted already i did a search and only found a bunch of old stuff version 4 Please help
    Computer King

    http://www.computerking.ca

    Sales, Service, and Hosting
    Email, Data, and Web Packages
    Ask about web design specials

    Affiliates
    http://www.computerking.ca/pages/lin...affiliates.htm

  2. #2
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Code:
    su - zimbra
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf --socket=/opt/zimbra/db/mysql.sock --check --all-databases

  3. #3
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

    Better generate charts for analysis.
    zmstat-chart -s /opt/zimbra/zmstat/<date dir> -d < dest dir>

    You might also want to look into stack traces generated.

Similar Threads

  1. ZCS 5.0.7 Install
    By clarky2k3 in forum Installation
    Replies: 9
    Last Post: 07-08-2008, 05:09 AM
  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, 06:05 AM
  3. Broken mysqld for xen install in FC5
    By bbaker in forum Installation
    Replies: 4
    Last Post: 11-20-2006, 07:52 AM
  4. Replies: 2
    Last Post: 10-02-2006, 08:44 AM
  5. System-Load with M4
    By billybofh in forum Administrators
    Replies: 7
    Last Post: 02-15-2006, 01:11 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
  •