mysql都需要监控什么_MySQL要监控什么？

如果您不太熟悉MySQL监控，开始可以看一看流行的监控软件。例如，下面列出了MySQL Cacti Plugin

Innodb Buffer Pool Activity

Pages Created

Pages Written

Pages Read

Innodb Buffer Pool Pages

Pool Size

Database Pages

Free Pages

Modified Pages

Inoodb File I/O

File Reads

Files Writes

Log Writes

File Fsyncs

Innodb Pending I/O

Aio Log Ios

Aio Sync ios

Buffer Pool Flushes

Chkp Writes

Ibuf Aio Reads

Log Flushes

Log Writes

Normal Aio Reads

Normal Aio Writes

Innodb Insert Buffer

Inserts

Merged

Merges

Innodb Log

Log Buffer Size

Log Bytes Written

Log Bytes Flushed

Unflushed Log

Innodb Row Operations

Rows Read

Rows Deleted

Rows Updated

Rows Inserted

Innodb Semaphores

Spin Rounds

Spin Waits

OS Waits

Innodb Transactions

Innodb Transactions

Current Transactions

History List

Read Views

MySQL Binary/Relay Logs

Binlog Cache use

Binlog Cache Disk Use

Binary Log Space

Relay Log Space

MySQL Command Counters

Questions

SELECT

DELETE

INSERT

UPDATE

REPLACE

LOAD

DELETE MULTI

INSERT SELECT

UPDATE MULTI

REPLACE SELECT

MySQL Connections

Max Connections

Max Used Connections

Aborted Clients

Aborted Connects

Threads Connected

Connections

MySQL Files and Tables

Table Cache

Open Tables

Open Files

Opened Tables

MySQL Network Traffic

Bytes Received

Bytes Sent

MySQL Processlist

State Closing Tables

State Copying to Tmp Table

State End

State Freeing Items

State Init

State Locked

State Login

State Preparing

State Reading From Net

State Sending Data

State Sorting Result

State Statistics

State Updating

State Writing to Net

State None

State Other

MySQL Query Cache

Queries In Cache

Hits

Inserts

Not Cached

Lowmem Prunes

MySQL Query Cache Memory

Query Cache Size

Free Memory

Total Blocks

Free Blocks

MySQL Replication

Slave Running

Slave Stopped

Slave Lag

Slave Open Temp Tables

Slave Retried Transactions

MySQL Select Types

Select Full Join

Select Full Range Join

Select Range

Select Range Check

Select Scan

MySQL Sorts

Sort Rows

Sort Range

Sort Merge Passes

Sort Scan

MySQL Table Locks

Table Locks Immediate

Table Locks Waited

Slow Queries

MySQL Temporary Objects

Created Tmp Tables

Created Tmp Disk Tables

Created Tmp Files

MySQL Threads

Thread Cache Size

Threads Created