about open cursors

Hi,

I need to make a report from all mysql productive databases and one of the item is to get the number of cursors open by hour.

how can i get this information?
is there a variable or sentence where i can obtain this information or is not posible in mysql?

Thanks for the help.

Any information about it.

Thanks for your help.

[B]gjuan wrote on Mon, 07 June 2010 21:40[/B]
Hi,

I need to make a report from all mysql productive databases and one of the item is to get the number of cursors open by hour.

how can i get this information?
is there a variable or sentence where i can obtain this information or is not posible in mysql?

Thanks for the help.

If you look at SHOW GLOBAL STATUS, you will see Com_prepare and some related variables. This is the number of times a statement is prepared, for example. Check the documentation – there are a few similar variables. I think one of them is probably what you are looking for.