mysql 当前状态_MySQL当前状态

+------------------------------------------+-------------+

| Variable_name                            | Value       |

+------------------------------------------+-------------+

| Aborted_clients                          | 187         | 客户端非法中断连接次数

| Aborted_connects                         | 13          | 连接mysql失败次数

| Connections                              | 2953463     | 连接mysql次数

| Created_tmp_disk_tables                  | 0           | 在磁盘上创建的临时表

| Created_tmp_files                        | 205         | 在内存上创建的临时文件

| Created_tmp_tables                       | 2           | 在内存上创建的临时表

| Delayed_errors                           | 0           | 延迟错误

| Flush_commands                           | 2           | 已执行的强制更新 (FLUSH) 语句数

| Handler_commit                           | 0           | 已执行的内部提交 (COMMIT) 语句数

| Handler_delete                           | 0           | 从表中删除行的次数

| Handler_read_first                       | 0           | 读取一个索引入口点的次数

| Handler_read_key                         | 0           | 根据索引读取行的请求数，该值很大，说明查询和表都建立了很好的索引

| Handler_read_rnd                         | 0           | 根据固定位置读取行的请求数

| Handler_read_rnd_next                    | 114         | 从数据文件中读取行的请求数

| Handler_rollback                         | 0           | 内部回滚 (ROLLBACK) 语句数

| Handler_update                           | 0           | 表中更新行的请求数

| Handler_write                            | 112         | 表中插入行的请求数

| Innodb_buffer_pool_pages_data            | 12884       | 非空页数(含脏页)

| Innodb_buffer_pool_pages_dirty           | 0           | 脏页数

| Innodb_buffer_pool_pages_total           | 65535       | 缓冲池总大小

| Innodb_buffer_pool_read_requests         | 61561553623 | InnoDB 完成的逻辑读请求数

| Innodb_buffer_pool_wait_free             | 0           | 写缓冲池等待的数量

| Innodb_buffer_pool_write_requests        | 8550265     | 写入InnoDB 缓冲池的次数

| Innodb_data_fsyncs                       | 155154      | 强制写硬盘次数

| Innodb_data_pending_fsyncs               | 0           | 当前挂起 fsync() 操作的数量

| Innodb_data_pending_reads                | 0           | 当前挂起的读操作数

| Innodb_data_pending_writes               | 0           | 当前挂起的写操作数

| Innodb_data_read                         | 0           | 读取的总数据量

| Innodb_data_reads                        | 227         | 读取的总次数

| Innodb_data_writes                       | 1045590     | 写的总次数

| Innodb_data_written                      | 30871437312 | 写总数据量

| Key_blocks_not_flushed                   | 0           | 键缓存中还没有被写入到磁盘的键块数

| Key_blocks_unused                        | 47608       | 键缓存中未使用的块数

| Key_blocks_used                          | 53585       | 键缓存中已经使用的块数

| Key_read_requests                        | 29253914    | 从缓存中读取键块的请求次数

| Key_reads                                | 5373        | 从磁盘中物理读取键块的次数

| Key_write_requests                       | 4372620     | 将一个键块写入缓存的请求数

| Key_writes                               | 4334074     | 将键块物理写入到磁盘的次数

| Qcache_free_blocks                       | 20560       | 查询缓存中空闲的内存块数

| Qcache_free_memory                       | 72954648    | 查询缓存中空闲的内存总数

| Qcache_hits                              | 550888      | 缓存命中数

| Qcache_inserts                           | 3172288     | 加入到缓存的查询数

| Qcache_not_cached                        | 16444       | 未缓存的查询数

| Qcache_queries_in_cache                  | 55569       | 在缓存中注册的查询数

| Qcache_total_blocks                      | 131812      | 查询缓存中的总块数

| Threads_cached                           | 27          | 线程缓存中线程的数量

| Threads_connected                        | 1           | 当前打开的连接数

| Threads_created                          | 39780       | 当前用于控制连接的线程数

| Threads_running                          | 1           | 非睡眠状态的线程数量

|Uptime||服务器已经工作的秒数

+------------------------------------------+-------------+