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. -N ------------------------------------------------------------------------------ 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
