MySQL 5.5 who is creating temp tables on disk

[Till Brinkmann]

Hello,

so we face a problem regarding mysql is creating temp tables on disk.

The solution will be to change the sort_buffer_size.

So here is my question: How do I can see (select) which databaseusers or select statement is creating the temp tables on disk. Is there anything like 'select * from temp_table_on_disk';

Thanks for the advice !