...from 'show processlist'. I don't have update/insert queries showing up any more, but it looks like queries with state 'Copying to tmp table' are backing up.
How bad is it when mysql has to use tmp tables? Any tips for improving the queries?