Cliff, still no explain still not table structure. Until that happens enjoy the 5 hour club.
Donny > -----Original Message----- > From: Cliff Daniel [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 24, 2004 6:41 PM > To: Donny Simonton > Cc: 'Tim Cutts'; [EMAIL PROTECTED] > Subject: Re: SLOW 22million rows, 5 hour query? > > http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html > > " Do not use DELAYED with INSERT ... SELECT. " > > > With respect to the table structure...can you explain how when you have > to read every single row regardless how the structure (assuming you are > going down the path of idexes) affects the query? > > Cliff > > Donny Simonton <[EMAIL PROTECTED]> writes: > > Use insert delayed, and you will cut your time in half. At least with > my > > experience. But also how long does it actually take to run the query > > itself. Giving a summary explain doesn't help much. You really need a > > table structure that the select is using and a full explain. > > > > Donny > > > > > -----Original Message----- > > > From: Tim Cutts [mailto:[EMAIL PROTECTED] > > > Sent: Saturday, April 24, 2004 6:02 AM > > > To: [EMAIL PROTECTED] > > > Cc: [EMAIL PROTECTED] > > > Subject: Re: SLOW 22million rows, 5 hour query? > > > > > > > > > On 23 Apr 2004, at 9:48 pm, [EMAIL PROTECTED] wrote: > > > > > > > Relevant `explain` details: > > > > Full table scan: 22,371,273 rows, Using temporary; Using filesort > > > > > > The filesort is a giveaway. Can you increase the sort buffer size so > > > that the sort can happen in memory rather than having to use a file to > > > sort? > > > > > > Tim > > > > > > -- > > > Dr Tim Cutts > > > Informatics Systems Group > > > Wellcome Trust Sanger Institute > > > Hinxton, Cambridge, CB10 1SA, UK > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
