Hi,
I have noticed quite a few queries appear in the slow query log. I then do a explain on those queries, however, the execution plan for these queries look OK to me.
This is one of the query:
select handset0_.id as id0_, handset0_.version as version0_,
handset0_.imei as imei0_, handset0_.model as model0_,
handset0_.variant as variant0_
from handset handset0_
where handset0_.id=9200;
(please execute the weired column naming as it's a prepared statement from Hibernate.)
+----+-------------+-----------+-------+---------------+---- -----+---------+-------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+-------+---------------+---- -----+---------+-------+------+-------+
| 1 | SIMPLE | handset0_ | const | PRIMARY | PRIMARY | 4 | const | 1 | |
+----+-------------+-----------+-------+---------------+---- -----+---------+-------+------+-------+
What else should I look to top this query appear in the slow query log?
Thanks,
Aimee
I have noticed quite a few queries appear in the slow query log. I then do a explain on those queries, however, the execution plan for these queries look OK to me.
This is one of the query:
select handset0_.id as id0_, handset0_.version as version0_,
handset0_.imei as imei0_, handset0_.model as model0_,
handset0_.variant as variant0_
from handset handset0_
where handset0_.id=9200;
(please execute the weired column naming as it's a prepared statement from Hibernate.)
+----+-------------+-----------+-------+---------------+---- -----+---------+-------+------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------+-------+---------------+---- -----+---------+-------+------+-------+
| 1 | SIMPLE | handset0_ | const | PRIMARY | PRIMARY | 4 | const | 1 | |
+----+-------------+-----------+-------+---------------+---- -----+---------+-------+------+-------+
What else should I look to top this query appear in the slow query log?
Thanks,
Aimee
( I got handled over this system which already has NFS configured and been told it's not possible to change it at the moment).
Comment