Van egy nagy halom slow-query-m:
# Time: 090901 12:00:01
# u...@host: DBMail[DBMail] @ localhost []
# Query_time: 52.065513 Lock_time: 0.000205 Rows_sent: 0
Rows_examined: 307816
SET timestamp=1251799201;
SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON
m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id
JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=29
AND n.headername IN ('resent-message-id','message-id') AND
v.headervalue='<x...@x>' AND p.internal_date > NOW() - INTERVAL 3 DAY;
De ha meg akarom nezni, mi tortenik, csak ennyi rows latszik (a
felesleges oszlopokat kivagtam):
+----+-------------++--------++----------------------+---------++------++
| id | select_type || type || key | key_len || rows |
+----+-------------++--------++----------------------+---------++------++
| 1 | SIMPLE || range || headername | 302 || 2 |
| 1 | SIMPLE || ref || headername_id | 8 || 2889 |
| 1 | SIMPLE || eq_ref || PRIMARY | 8 || 1 |
| 1 | SIMPLE || ref || physmessage_id_index | 8 || 1 |
+----+-------------++--------++----------------------+---------++------++
Valami otlet, hogyan lehet reprodukalni/kideriteni?
--
Gabor HALASZ <[email protected]>
_________________________________________________
linux lista - [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux
