Sorry my question may have been bad.
MySQL version is 5.0.37.
I tried slow query logging with long query set to 1 sec.
I came up with 3 sec and 6 sec queries and both of them are select query.
When I searched google it said that I need to use paging but since it was
working on the old server I do
Hello
Recently I changed my servers.
The old server spec is Core2Duo E6600 with 4gb ram and 320gb SATA.
The new server spec is Dual Opteron 2.1ghz with 4gb ram and 73gb 15kRPM SAS.
Now here comes the problem.
I generated 3gb forum backup (sql format) and putted it back in to the new
server.
It to
