student
07-17-2008, 04:51 AM
Hello,
I have many queries that are well optimized using indexes.
when I execute these queries in phpmyadmin using profiling, they always show less than 0.0172 sec etc.. like 0.00032 sec etc..
Example:
SELECT id FROM table WHERE column='something' limit 1
But when I look in the slow query log, i find a lot of these queries that exceed 2 seconds.
In this table, I estimate that there are around 99.9% selects and 0.1% updates.
I have used low_priority in those update queries.
Inserts and deletes are carried on once in a few days just for a few seconds.
Is there any locking issue that is causing slow queries?
If yes, how to solve it.
Can you please inform me why the queries are performing very well in phpmyadmin but are causing slow queries?
Thank you
I have many queries that are well optimized using indexes.
when I execute these queries in phpmyadmin using profiling, they always show less than 0.0172 sec etc.. like 0.00032 sec etc..
Example:
SELECT id FROM table WHERE column='something' limit 1
But when I look in the slow query log, i find a lot of these queries that exceed 2 seconds.
In this table, I estimate that there are around 99.9% selects and 0.1% updates.
I have used low_priority in those update queries.
Inserts and deletes are carried on once in a few days just for a few seconds.
Is there any locking issue that is causing slow queries?
If yes, how to solve it.
Can you please inform me why the queries are performing very well in phpmyadmin but are causing slow queries?
Thank you