3
MySQL数据库巡检手册 MySQL DBA必备
免费下载
MySQL
Linux
24
dmidecode | grep "Product Name"
CPU
cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -c
free -m
df -h
ifconfig -a
uname -a
CPU
top
CPU80%
CPU
uptime
CPU10
free -m
80%
swap
free -m
swap10%
df -ah
80%
iostat -xkd 1
util10%
netstat –an |grep LISTEN
iftop
50%
ps aux | more
ps -ef | grep mysqld
portdatadir
select version()
du -sh
show table status
RowsData_length
Rows10000000
show variables like '%log_error%';
ERROR
show variables like '%slow%';
backlog
max_allowed_packet
interactive_timeout
wait_timeout
skip_name_resolve
max_connections
log_bin
expire_logs_days
open_file_limit
table_open_cache
thread_cache_size
sort_buffer_size
join_buffer_size
innodb_buffer_pool_size
innodb_file_per_table
innodb_open_files
innodb_thread_concurrency
innodb_flush_log_at_commit
innodb_log_buffer_size
innodb_log_file_size
innodb_log_files_in_group
general_log
log_error
slow_query_log
long_query_time
QPS
show status like ‘queries’
QPS
show status like ‘com_%’
com_select
com_insert;
com_update;com_delete
show status like
‘%Threads_connected%’
max_connections
show status like
'%max_used_connections%';
show variables like
'%max_connections%';
max_used_connections
max_connections
max_connections
show variables like ‘%Aborted%’
Aborted_clients
Aborted_connects
of 3
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论