List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:June 6 2003 8:25pm
Subject:Re: Speeding up "copy to tmp table"
View as plain text  
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 isn't being utilized.  

You tell us.

Is it disk or CPU bound right now?
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.13: up 3 days, processed 118,915,461 queries (395/sec. avg)
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