Problem With Mysql

[lorenzaccio]

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.

[ArcaneMagus]

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)

[ArcaneMagus]

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

[lorenzaccio]

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.

[ArcaneMagus]

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?

[lorenzaccio]

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.

[ArcaneMagus]

What is the output of the following two commands?

vmstat
vmstat-d

[lorenzaccio]

Hi again,

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

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

[phoenix]

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.

[uxbod]

Output of

free