Speeding up copy to tmp table
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
Re: Speeding up copy to tmp table
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! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 3 days, processed 118,915,461 queries (395/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Speeding up copy to tmp table
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]