asked on MYSQL why is it sometimes too slow ?
Hello experts,
we have a small database in mysql,
its usually performs really fast
but sometimes when requesting a very simple query
it will take too long to respond... like 30 secs o more... and its a very simple query.
and the table is too small....
I have noticed that maybe there are other connections still open and i think not operating.
Could this be the cause and if so what tools do i have to control this ?
Regards
we have a small database in mysql,
its usually performs really fast
but sometimes when requesting a very simple query
it will take too long to respond... like 30 secs o more... and its a very simple query.
and the table is too small....
I have noticed that maybe there are other connections still open and i think not operating.
Could this be the cause and if so what tools do i have to control this ?
Regards
DatabasesMySQL Server
Last Comment
RGuillermo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I would say that when having multiple connections accessing the table at same time, you will face this poor query performance.
Do you have any index created in that table?
Do you have any index created in that table?
ASKER
Thanks to all Experts, it took us a while test all posibilites
It'd be better if you can post your findings for people who come surfing here.
ASKER
Two findings.
1. We improved the design of our database... normalizing and eliminating reduce where possible.
2. having adequate indexes and not too many
3. when executing queries be careful with search criteria......
4. If all the above are met very likely you get a fine performance or at least acceptable.
All these come from our programmers...
Regards
1. We improved the design of our database... normalizing and eliminating reduce where possible.
2. having adequate indexes and not too many
3. when executing queries be careful with search criteria......
4. If all the above are met very likely you get a fine performance or at least acceptable.
All these come from our programmers...
Regards
7.4 Visual Explain Plan
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html