uhm boh quello è quello che mi ha girato il responsabile della server farm...
mi ha mandato anche questo che sono le ultime query prima del riavvio di mysql, ma quelle stesse query in altri momenti della giornata persino non sono assolutamente lente...
query che cmq sono state disattivate e il problema non si è risolto
cosa ti potrebbe servire d'altro per capire dove sta il problema che chiedo?
root@www:~# tail -5000 /var/log/mysql-slow.log|grep -A10 -B10 start
select count(id) as TOT_ITEM from products WHERE id in(select id_pro from product_sections where id_sec in(5747,5745,5748,5746,5589)); # User@Host: root[root] @ localhost [] # Query_time: 1546 Lock_time: 0 Rows_sent: 0 Rows_examined: 39159772 SELECT * FROM products WHERE id_pla = 2 AND id in(select id_pro from product_sections where id_sec
in(3281,3280,3286,3279,3283,3275,3278,3282,3759,3276,3285,3284,3287,3277,3274))
ORDER BY salecount desc LIMIT 20,10;
User@Host: root[root] @ localhost []
Query_time: 297 Lock_time: 0 Rows_sent: 0 Rows_examined: 7731184 SELECT * FROM products WHERE id_pla = 4 AND id in(select id_pro from product_sections where id_sec
in(6170,6180,6183,6179,6171,6184,6173,6177,6176,6178,6175,6181,6174,6182,6172,5636))
ORDER BY salecount desc LIMIT 410,10;
User@Host: root[root] @ localhost []
Query_time: 109 Lock_time: 0 Rows_sent: 0 Rows_examined: 2168 select count(id) as TOT_ITEM from products WHERE id_pla = 1 AND id in(select id_pro from product_sections where id_sec in(5760,5761,5763,5762,5774,5765,5772,5766,5770,5764,5768,5769,5773,5771,5767,5591));
/usr/libexec/mysqld, Version: 5.0.24a-log. started with:
Tcp port: 0 Unix socket: (null)
Time Id Command Argument
Time: 080520 18:58:19
User@Host: root[root] @ localhost []
Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 4145 use handango_db; select count(id) as TOT_ITEM from products WHERE id_pla = 5 AND id in(select id_pro from product_sections where id_sec in(6674,6667,6666,6675,6672,6676,6677,6673,6665,6669,6664,6668,6663,6593));
Time: 080520 18:58:21
User@Host: root[root] @ localhost []
Query_time: 2 Lock_time: 0 Rows_sent: 10 Rows_examined: 4155
