Using The Sqlyog Profiler

[paul george]

Hi' all; .. I'm a newbie to database design. So I would be grateful for any assistance you can offer me in fine tuning my database!

I ran the mySQL SELECT statement below; on my test database that holds 52 tables of various sizes.

The table I conducted this test on; had only 20 rows in it.

SELECT code_reff , brand_id 


FROM products.product_codes 


WHERE (brand_id = 4) 


OR (brand_id =12); 

When I view the SQLyog Profiler results; I see a result for (freeing items) 0.00525 sec;

with a percentage that ranges between 72.01646 to 91.00245% in repeated tests.

What do these figures mean? Is this fast/slow; good or bad? Freeing items! What is the best result a high percentage or a low percentage?

Thank's to you all!

Paul

[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