messages.created needs index

[matthew.kent]

Was watching the following stack up quite a bit this morning

# Query_time: 11  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM messages
             WHERE  created < FROM_UNIXTIME(1212424204);

# Query_time: 11  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM messages
             WHERE  created < FROM_UNIXTIME(1212424205)

this on a dedicated db using mysql 5.0.54 enterprise.

table is holding some 155000 rows right now which makes the delete without an index on the where clause pretty rough.

Solution is to add an index to messages.created and they go so quick I can't see them in the process list anymore :)

[alec]

Fixed in r1522.