El 06/07/10 12:14, Nathan M escribió: > On Fri, Jul 2, 2010 at 8:41 PM, Rodolfo Gonzalez Gonzalez > <[email protected]> wrote: >> On 02/07/10 19:29, Nathan M wrote: >>> >>> The thing that gets me is the Query time being 264 seconds that when >>> watching status sits in status 'Copying to tmp table'. I know InnoDB >> >> You got it. When MySQL goes "copying to tmp table"... that's bad. Which >> version are you using? Which fs for your tmp partition? > > Using MySQL 5.1.37 > Filesystem is ext3, noatime option at mount. > > I'm confident the /tmp partition is not used by mysql/innodb. Copying > to tmp table is a memory thing in SQL when joining several tables so > it can compile results and return them. It's this process that seems > super slow.
Hmmm, I've seen MySQL 5.0 creating tmp tables on disk... ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org
