Offhand, have you tried disabling the option "Automatic Similar Thread Search?" It might help to look at the queries running as well in debug mode to see where the hold up might be.

Do you have any news? Have you managed to set up slow query log?

orban,

I have this in the my.cnf file:

[mysqld_safe]
log-error=/var/log/mysqld.log
log-slow-queries=/var/log/mysqldslow.log
pid-file=/var/run/mysqld/mysqld.pid

But it hasn't logged the slow queries and I am showing 8 slow queries now. The good news is I've done some more MySQL tweaking with help from a MySQL focused forum and it seems to be helping. Will keep everyone updated.

You aren't swapping by any chance are you?

Hey bud, it's still running slow.