Using The Sqlyog Profiler

[Mahesh]

“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.com/bug.php?id=43758.

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

Please go through these links:

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_query_cache_size

http://dev.mysql.com/doc/refman/5.1/en/query-cache.html

[peterlaursen]

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.  

[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]

'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

[Author]

Posts