I have many queries that are well optimized using indexes.
when I execute these queries in phpmyadmin using profiling, they always show something like 0.00032 sec etc…
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.
So, I think they may not be causing these slow queries.
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?
Let me know if you would like to know more information.