Yes it could be limited to 1 specific query. If a query is run for which MySQL decides it is better to use a temporary table to use for sorting for example and your tmp-directory don't have enough space to hold all the data for that specific query, then this could happen.
Make sure you have also enough free space in your tmp-directory and run a repair on all tables.
|