MySQL DBA刚入职时如何快速拥抱新的环境(四)
#######################################
Key Cache | 16.0M
Pct Used | 20%
Unflushed | 0%
--这部分是MyISAM的部分
(12)第12部分
# Security ###################################################
Users | 9 users, 1 anon, 4 w/o pw, 9 old pw
Old Passwords | ON
--这部分从 grants table 的mysql表提取出来
--显示了显示了有多少用户以及各种可能的安全配置
(13)第13部分
# Binary Logging #############################################
Binlogs | 12
Zero-Sized | 0
Total Size | 62.5M
binlog_format | MIXED
expire_logs_days | 0
sync_binlog | 0
server_id | 1
binlog_do_db |
binlog_ignore_db |
--这部分显示了二进制日志的配置
(14)第14部分
# Noteworthy Variables #######################################
Auto-Inc Incr/Offset | 1/1
default_storage_engine | InnoDB
flush_time | 0
init_connect |
init_file |
sql_mode |
join_buffer_size | 128k
sort_buffer_size | 512k
read_buffer_size | 256k
read_rnd_buffer_size | 512k
bulk_insert_buffer | 0.00
max_heap_table_size | 16M
tmp_table_size | 16M
max_allowed_packet | 1M
thread_stack | 256k
log | OFF
log_error | /home/mysql/mysql/log/alert.log
log_warnings | 1
log_slow_queries | ON
log_queries_not_using_indexes | OFF
log_slave_updates | OFF
--这部分展示了服务器的几个关键配置
(15)第15部分
# Configuration File #########################################
Config File | /etc/my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
basedir = /home/mysql/mysql
datadir = /home/mysql/mysql/data
log-error = /home/mysql/mysql/log/alert.log
log_slow_queries = /home/mysql/mysql/log/slow.log
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
innodb_file_per_table = 1
log-bin = mysql-bin
binlog_format = mixed
server-id = 1
sync_binlog = 1
innodb_support_xa = 1
innodb_flush_log_at_trx_commit = 2
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
# The End ####################################################
--如您所见、这部分完完全全来自 my.cnf、这里不赘述了
其实分析完 pt-mysql-summary 之后、你基本就已经对你即将管理的Server知根知底了
接下来的 Innotop 能给您想知道的部分锦上添花的作用
更多了解请查询：code.google.c