What steps can be taken to speed up queries that show state=copy to tmp
table in show processlist? I am running MySql on a dual Xeon system
running Windows 2000 server with 10 10K rpm drives in 5 raid 0 arrays
and plenty of ram that isn't being utilized.
Sam
On Fri, Jun 06, 2003 at 11:32:25AM -0500, Sam Jumper wrote:
What steps can be taken to speed up queries that show state=copy to tmp
table in show processlist? I am running MySql on a dual Xeon system
running Windows 2000 server with 10 10K rpm drives in 5 raid 0 arrays
and plenty of ram that
So you have no redundancy? 5 arrays of raid 0 (2 disks each) = lose a
disk and your pooched..
suggestion:
reconfigure to raid 0+1 (more than 2 disks a set) for added perf ?
On Fri, 6 Jun 2003, Sam Jumper wrote:
What steps can be taken to speed up queries that show state=copy to tmp
table in