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!