Imam problem sa sporim SELECT upitom. Nekada se izvrši za 30s, a nekada mu treba 2-3min.
Upit je:
SELECT ID_log, gtime, uredjaj, event FROM log FORCE INDEX (gtime_uredjaj_idx) WHERE gtime BETWEEN '2014-10-10' AND '2014-10-30' AND uredjaj=1234;
Explain za ovaj upit je:
+----+-------------+-------+-------+-------------------+-------------------+---------+------+----------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+-------+-------------------+-------------------+---------+------+----------+-------------+
| 1 | SIMPLE | log | range | gtime_uredjaj_idx | gtime_uredjaj_idx | 7 | NULL | 10683481 | Using where |
+----+-------------+-------+-------+-------------------+-------------------+---------+------+----------+-------------+
Sve vrijeme SELECT zašteka na State: Sending data.
Ima li neki buffer ili nešto slično da se poveća, da ovo ubrzam malo?
MySQL je 5.5.24, 32G RAM