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 <halas...@freemail.hu> _________________________________________________ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux