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 ?
7.4 Visual Explain Plan