-
Notifications
You must be signed in to change notification settings - Fork 446
Status Variables
Kevin Crane edited this page Apr 15, 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 |
Thread_running_max | Numeric | Session, Global |
Read_queries | Numeric | Session, Global |
Write_queries | Numeric | Session, Global |
Total_queries_rejected | Numeric | Session, Global |
Write_queries_rejected | Numeric | Session, Global |
Write_queries_running | Numeric | Session, Global |
-
Number of statements that exceeded the maximum execution time.
-
Number of statements that were time-limited.
-
Number of failed attempts to set the maximum execution time.
-
Number of insert/upsert statements that does not insert or update any row.
-
Number of rows sent back to clients.
-
Number of rows examined by MySQL before sent back to clients.
-
Max number of running threads since last execution of SHOW STATUS.
-
Number of read queries executed.
-
Number of write queries executed.
-
Number of total queries that have been rejected due to throttling.
-
Number of total write queries that have been rejected due to throttling.
-
Number of write queries that are currently executing.