1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

mysql.slow.log shows smtp_poplocks

Discussion in 'Plesk for Linux - 8.x and Older' started by tkalfaoglu, Jan 22, 2007.

  1. tkalfaoglu

    tkalfaoglu Regular Pleskian

    30
    68%
    Joined:
    Oct 6, 2005
    Messages:
    290
    Likes Received:
    1
    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
     
Loading...