[paul george]

'Mahesh' wrote on '07:

“Freeing Items” — The thread has executed a command. This state is usually followed by cleaning up.

But still query in “freeing items” state more than 70% is bad indeed. Also this MySQL issue might be related to this http://bugs.mysql.co…g.php?id=43758.

You can try by Enabling “Query Cache” for more optimal result.

Please go through these links:

http://dev.mysql.com…uery_cache_size

http://dev.mysql.com…uery-cache.html

Thank you for your help; I did follow the links you provided and found the information in them very helpful!

Paul

[paul george]

'peterlaursen' wrote on '07:

When calculating percentages on very small numbers I do not think you should put much emphasis on the %tage. The percentage may increase with subsequent executions if other operations are faster and this one take the same time. 'freeing items' is basically OS call that makes memory temporarily used by the server available to the OS again.

Things are a little clearer to me now! So thanks for your help!

Paul

[paul george]

'marcm' wrote on '02:

I just wanted to say thanks for SQLyog. I finally upgraded to the Enterprise version, but I've been using the community version for a while now. I pretty much use it everyday. I love it and I couldn't develop the way I do without it.

I highly recommend this tool to anyone who uses MySQL.

Please keep up the great work.

Hi 'marcm' .. I agree with you. I too; am using the Enterprise version of SQLyog. The team behind this product can be congratulated for providing such an advanced tool, that helps everyone who wishes to fast track the development of large mySQL databases.

[Author]

Posts