Re: Speeding up "copy to tmp table"

[colbey]

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 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
>