SHOW GLOBAL STATUS like 'Created_tmp_disk_tables';

performance_schema.events_statements_history/events_statements_history_long

sudo lsof -s | awk '{if ($1 == "mysqld" && $9 ~ //tmp/) size+=$7} END {print size}'