MySQL Server Views
What each subview of the Server view is for.
The Server view covers everything about the server that isn't about one schema object. Its subviews are listed in the sidebar on the left. Each has its own page with columns explained.
| View | Answers |
|---|---|
| Events | What scheduled events exist, when did they last run, and is the scheduler on? |
| Users | Who can connect, from where, and what may they do? |
| Variables | How is the server configured, and what can I change without restarting? |
| InnoDB Status | What is the storage engine doing: buffer pool, transactions, last deadlock, pending I/O? |
| Locks | Who is blocking whom, right now? |
| Index Usage | Which indexes are never used, and which tables are read without one? |
| Processes | Who is connected and what is each connection running? |
| Server Status | How busy is the server, and how has that changed? |
| Query Digest | Which query patterns cost the most time overall? |
| Error Log | What has the server complained about? |
| Slow Queries | Which individual queries crossed the slow threshold, with full text? |
Starting Points #
Something is slow right now
-
Processes: find the long-running query and stop it if needed.
-
Locks: if queries are waiting rather than working, find the blocking session.
-
InnoDB Status: check queries queued inside InnoDB and the buffer pool hit rate.
Something is slow in general
-
Query Digest: rank query patterns by total time.
-
Slow Queries: read the worst offenders' full text and execution details.
-
Index Usage: find full-scanned tables and indexes that only cost writes.
Routine housekeeping
-
Index Usage: drop indexes nothing reads.
-
Error Log: read what the server has been warning about.
-
Variables: confirm the configuration is what you think it is.