Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Problem With Mysql

  1. #1
    lorenzaccio is offline Active Member
    Join Date
    May 2009
    Posts
    27
    Rep Power
    6

    Smile Problem With Mysql

    Hello forum,

    I have Zimbra OS version 5.16 on Ubuntu 6.04 TLS.
    I have ben trying to troubleshoot an issue with general slow performance.
    When I check zmcontrol status i have noticed

    zmlogswatchctl not running
    zmswatch not running

    restarted and OK

    then I follow those troubleshooting steps:

    - Ceck diskspace /dev/sda3 OK

    - Follow article trobleshooting logger

    Logger (ZCS 5.0.x and earlier) - Zimbra :: Wiki

    - check MYSQL: table they are all OK but

    MTA table responded in 3'40''

    - If "zmlogswatchctl is not running",


    A) the file /opt/zimbra/log/logswatch.pid exists, PID 23393

    B) there is a single /opt/zimbra/libexec/logswatch process. ==> there are two process running

    zimbra 23391 0.0 0.2 7600 4848 pts/0 S 04:54 0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-file=/opt/zimbra/conf/logswatchrc --use-cpan-file-tail --pid-file=/opt/zimbra/log/logswatch.pid --script-dir=/tmp -t /var/log/zimbra.log
    zimbra 2003 0.0 0.0 2884 820 pts/0 S+ 06:00 0:00 grep logswatch

    - logmysqladmin status
    Uptime: 24563 Threads: 2 Questions: 25069 Slow queries: 1022 Opens: 25 Flush tables: 1 Open tables: 19 Queries per second avg: 1.021

    - check nano logger_mysql_error.log and mysql_error.log


    091005 23:09:37 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    091005 23:09:37 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295


    -- mysqladmin version
    /opt/zimbra/mysql/bin/mysqladmin Ver 8.41 Distrib 5.0.67, for pc-linux-gnu




    I would like an advice i possible because from my small experience I cannot see anything really wrong except the warning option 'max_join_size': unsigned value which could be referred as a bug in mysq ( MySQL Bugs: #35346: max_join_size default value ) and logswatch.pid not maching with the running processes but I quite stucked....

    Any advice would be very welcome

    thanks very much

    l.

  2. #2
    ArcaneMagus's Avatar
    ArcaneMagus is offline Moderator
    Join Date
    Feb 2007
    Location
    Portland, OR
    Posts
    1,147
    Rep Power
    10

    Default

    Has this slow performance started recently, or has it always been that way?

    As for your pid mismatch, the PID seems to go to a wrapper script that launches the rest of it. (At least on 6.0.x)

  3. #3
    ArcaneMagus's Avatar
    ArcaneMagus is offline Moderator
    Join Date
    Feb 2007
    Location
    Portland, OR
    Posts
    1,147
    Rep Power
    10

    Default

    Ah I see that you already answered your own question and posted it in a different thread.

    http://www.zimbra.com/forums/migrati...16-6-00-a.html

    I am marking this thread solved. A post in this thread showing you had found your issue would have been nice

  4. #4
    lorenzaccio is offline Active Member
    Join Date
    May 2009
    Posts
    27
    Rep Power
    6

    Default

    HI ArcaneMagus,
    I don't understand what you mean?
    I post two thread and two different zimbra systems
    This, it's Zimbra 5.16 on Ubuntu 6.04. The other it's a completly different system I follow, where we have recently upgrade from 5.16 ( Ubuntu 8.04 ) to Zimbra 6.00. I don't ,just yet, see the connection of the two problems
    I don't think the thread should marked as closed ...
    thanks
    L.

  5. #5
    ArcaneMagus's Avatar
    ArcaneMagus is offline Moderator
    Join Date
    Feb 2007
    Location
    Portland, OR
    Posts
    1,147
    Rep Power
    10

    Default

    I am sorry, I saw this thread with you talking about a system acting slow, and then another thread 14 minutes later with this sentence "I have noticed very slow performance and attempting to troubleshoot the issue I realised that there was an intense activity of CLAMAV in coincidence with the server unresponsiveness.." and thought you were talking about the same system, not two different systems both acting slow.

    Could you answer the question as to whether this issue started recently?

  6. #6
    lorenzaccio is offline Active Member
    Join Date
    May 2009
    Posts
    27
    Rep Power
    6

    Default

    Hi, It has been like that for a while I would say, sometimes faster performance and sometimes very slow. I tought of a problem with logger and/or mysql tables. Few months ago we also tried to shrink the mysqlDB according the docs but it seems the issue still there

    thx
    l.

  7. #7
    ArcaneMagus's Avatar
    ArcaneMagus is offline Moderator
    Join Date
    Feb 2007
    Location
    Portland, OR
    Posts
    1,147
    Rep Power
    10

    Default

    What is the output of the following two commands?
    Code:
    vmstat
    vmstat-d

  8. #8
    lorenzaccio is offline Active Member
    Join Date
    May 2009
    Posts
    27
    Rep Power
    6

    Default

    Hi again,

    Code:
    vmstat :
    root@Mail:/# vmstat
    procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
     r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy id wa
     0  0   6660 117952  72440 545776    1    1     3     7    6     2  8  1 89  2
    Code:
    root@Mail:/# vmstat -d
    disk- ------------reads------------ ------------writes----------- -----IO------
           total merged sectors      ms  total merged sectors      ms    cur    sec
    ram0       0      0       0       0      0      0       0       0      0      0
    ram1       0      0       0       0      0      0       0       0      0      0
    ram2       0      0       0       0      0      0       0       0      0      0
    ram3       0      0       0       0      0      0       0       0      0      0
    ram4       0      0       0       0      0      0       0       0      0      0
    ram5       0      0       0       0      0      0       0       0      0      0
    ram6       0      0       0       0      0      0       0       0      0      0
    ram7       0      0       0       0      0      0       0       0      0      0
    ram8       0      0       0       0      0      0       0       0      0      0
    ram9       0      0       0       0      0      0       0       0      0      0
    ram10      0      0       0       0      0      0       0       0      0      0
    ram11      0      0       0       0      0      0       0       0      0      0
    ram12      0      0       0       0      0      0       0       0      0      0
    ram13      0      0       0       0      0      0       0       0      0      0
    ram14      0      0       0       0      0      0       0       0      0      0
    ram15      0      0       0       0      0      0       0       0      0      0
    sda   16035729 1891393 721096904 274877650 33059801 81921131 1099487344 18429705
    60      0 136292
    sdb       32    202     467      60      0      0       0       0      0      0
    fd0        0      0       0       0      0      0       0       0      0      0
    sr0        0      0       0       0      0      0       0       0      0      0
    dm-0       0      0       0       0      0      0       0       0      0      0
    disk- ------------reads------------ ------------writes----------- -----IO------
           total merged sectors      ms  total merged sectors      ms    cur    sec
    dm-1       0      0       0       0      0      0       0       0      0      0
    dm-2       0      0       0       0      0      0       0       0      0      0
    dm-3       0      0       0       0      0      0       0       0      0      0
    md0        0      0       0       0      0      0       0       0      0      0
    md1        0      0       0       0      0      0       0       0      0      0
    md2        0      0       0       0      0      0       0       0      0      0
    md3        0      0       0       0      0      0       0       0      0      0
    thanks
    Lorenzo
    Last edited by phoenix; 10-23-2009 at 02:42 AM.

  9. #9
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,474
    Rep Power
    56

    Default

    The output is easier for people to read if you format it using 'code' tags (the # hash symbol above the editing section of a reply) rather than just a copy/paste.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  10. #10
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Output of
    Code:
    free

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem with MYSQL "mysql.host doesn't exist
    By kaltera in forum Installation
    Replies: 4
    Last Post: 06-04-2010, 12:58 PM
  2. Replies: 0
    Last Post: 04-24-2009, 09:37 AM
  3. Replies: 3
    Last Post: 02-04-2009, 01:15 PM
  4. Replies: 0
    Last Post: 07-08-2008, 03:01 PM
  5. Installation fails, possible mysql problem
    By webminster in forum Installation
    Replies: 6
    Last Post: 09-09-2005, 02:41 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
  •