•  

Announcement

Announcement Module
Collapse
No announcement yet.

about open cursors

Page Title Module
Move Remove Collapse
Conversation Detail Module
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts

  • about open cursors

    #1
    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.
    Tags: None

  • #2
    Any information about it.

    Thanks for your help.

    gjuan wrote on Mon, 07 June 2010 21:40

    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.

    Comment


    • #3
      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.

      Comment

      Working...
      X