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
  • Post a new comment

    Error

    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    switch
    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    Help
  • 2 comments