On 7/6/10 1:27 PM, Rodolfo Gonzalez 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...
Seconded...I saw it this morning in /var/tmp with an innodb table..
-Dave
--
Dave McGuire
Port Charlotte, FL
------------------------------------------------------------------------------
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
AMaViS-user@lists.sourceforge.net
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
