| 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 Jumper | 6 Jun |
| • Re: Speeding up "copy to tmp table" | colbey | 6 Jun |
| • Re: Speeding up "copy to tmp table" | Jeremy Zawodny | 6 Jun |
