• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

mysql.slow.log shows smtp_poplocks

tkalfaoglu

Silver Pleskian
my mysql slow queries log file shows:
SET timestamp=1169471897;
delete from smtp_poplocks where ((lock_time < DATE_SUB(NOW(), INTERVAL 30 MINUTE)) and (lock_time IS NOT NULL));
# User@Host: admin[admin] @ localhost []
# Query_time: 19 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SET timestamp=1169471897;
delete from smtp_poplocks where ((lock_time < DATE_SUB(NOW(), INTERVAL 30 MINUTE)) and (lock_time IS NOT NULL));
# User@Host: admin[admin] @ localhost []
# Query_time: 18 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SET timestamp=1169471897;
delete from smtp_poplocks where ((lock_time < DATE_SUB(NOW(), INTERVAL 30 MINUTE)) and (lock_time IS NOT NULL));

Should I run an optimize, or try to create an index for this table??

Thanks!
-turgut
 
Back
Top