Skip to content

Status Variables

Liang Guo edited this page Mar 14, 2014 · 12 revisions

Status variables that provide information about the Twitter MySQL server operation.

Variable Name Variable Type Variable Scope
Max_statement_time_exceeded Numeric Session, Global
Max_statement_time_set Numeric Session, Global
Max_statement_time_set_failed Numeric Session, Global
Com_insert_noop Numeric Session, Global
Rows_sent Numeric Session, Global
Rows_examined Numeric Session, Global
  • Max_statement_time_exceeded

    Number of statements that exceeded the maximum execution time.

  • Max_statement_time_set

    Number of statements that were time-limited.

  • Max_statement_time_set_failed

    Number of failed attempts to set the maximum execution time.

  • Com_insert_noop

    Number of insert/upsert statements that does not insert or update any row.

  • Rows_sent

    Number of rows sent back to clients.

  • Rows_examined

    Number of rows examined by MySQL before sent back to clients.

  • Thread_running_max

    Max number of running threads since last execution of SHOW STATUS.