MySQL Temporary Tables
Not quite what you asked for, but this query may help:

mysql&gt; SELECT db, name FROM mysql.proc WHERE body LIKE '%temporary%';
+---------------+-----------------------------------+
| db            | name                              |
+---------------+-----------------------------------+
| common_schema | rdebug_compile_routine            |
| common_schema | _get_sql_dependencies_internal    |
| common_schema | query_checksum                    |
| common_schema | _split_cleanup_dependency_tables  |
| common_schema | _split_generate_dependency_tables |
+---------------+-----------------------------------+


If /tmp is in a separate filesystem, you are cruisin' for a bruisin'.  Change tmpdir to point to some directory in the main FS.