It looks like the database was trying to update 30593 rows, and maybe it was taking a long time. Since no keys are identified in the 'explain', make user uuser_id and file_id have indexes on them. Posting the results of "show create table files" will help.
David I.
- 173
- 1
- 6