I have converted my main table to Innodb from MyIsam to improve db speed (locking issues).
Since doing so my macing is grinding to a halt, when looking at the connections most of then seem to say 'Copying to tmp table'. Im assuming this is a disk based table and as a result is slowing down the process. I cant understand why the Server is doing this.
Is is a memory allocation issue? (I have reinstalled my server with a high volume setting)
A Query issue? (It happens on most queries, but didnt when I used a MyIsam table)
I have searched google to see why 'copying to tmp table' happens but have not got any answers.
My servers dying!