List:General Discussion« Previous MessageNext Message »
From:Sam Jumper Date:June 6 2003 6:32pm
Subject:Speeding up "copy to tmp table"
View as plain text  
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

Thread
Speeding up "copy to tmp table"Sam Jumper6 Jun
  • Re: Speeding up "copy to tmp table"colbey6 Jun
  • Re: Speeding up "copy to tmp table"Jeremy Zawodny6 Jun