Mark Atwood (fallenpegasus) wrote,
Mark Atwood
fallenpegasus

Weird situation, tuning a MySQL db and query, what creates tmp files?

I'm trying to figure out for a friend what results in something like this

Restart the MySQL server and then run the query once. Then check the status variables.

Created_tmp_disk_tables = 0
Created_tmp_files = 362
Created_tmp_tables = 2
Sort_scan = 0
Sort_merge_passes = 0

What could be creating all those tmp files? It's not sorting on disk....
Tags: mysql
Subscribe

  • I'm back...

    After half a month in transit or on the playa, I'm back. I may write up some of my experiences and thoughts that touched me while I was out in the…

  • Burning Man, contact information

    Starting on Monday, I will be at Burning Man, and will be more or less unreachable from the default world. If you want to try to send me a postcard…

  • Mark Atwood speaking at Ignite OSCON 2010

    Mark Atwood speaking at Ignite OSCON 2010 Originally uploaded by O'Reilly Conferences This entry was originally posted at…

  • Post a new comment

    Error

    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 2 comments