> Rows_examined: 307816 > +----+-------------++--------++----------------------+---------++------++ > | 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?
Ugyan azon a DB-n nezted az explain-t ahol lassu vagy esetleg egy masikon, pl slave-en? InnoDB? Az en multkori problemam? 'Kezzel' futtatva is sokaig tart a query? _________________________________________________ linux lista - linux@mlf.linux.rulez.org http://mlf2.linux.rulez.org/mailman/listinfo/linux