3
2
MySQL数据库巡检手册
5墨值下载
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
show global status like
'%threads_running%';
10
show status like
'%threads_created%';
show status like 'connections';
threads_created/connections
thread_cache_size
show full processlist;
InnoDB Buffer Pool
show status like
'Innodb_buffer_pool_read_reques
ts';
show status like
‘Innodb_buffer_pool_reads';
Innodb_buffer_pool_reads/
Innodb_buffer_pool_read_request
s
innodb_buffer_pool_size
show full processlist;
statewait for xxx
lock
InnoDB
show engine innodb status;
LATEST DETECTED
DEADLOCK
InnoDB
show engine innodb status;
TRANSACTIONS
ACTIVE
show global status like
‘%opened_tables%';
show variables like
'%table_open_cache%';
opened_tables
table_open_cache
show variables like
‘%query_cache%’
query
cache
show global status like '%tmp%';
Created_tmp_tables
Created_tmp_disk_tables
Created_tmp_files
Group By
binlog
show variables like ‘log-bin’
show slave status;
of 3
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
inspur dba
最新上传
下载排行榜
1
2
PostgreSQL 缓存命中率低？可以这么做.doc
3
达梦数据2024年年度报告.pdf
4
北京大学 - DeepSeek与新媒体运营.pdf
5
centos7下oracle11.2.0.4 rac安装详细图文（虚拟机模拟多路径）.docx
6
【GoldenDB】一种分布式数据库变更数据检索方法、装置、设备及介质_CN202411914568.4_金篆信科有限责任公司.pdf
7
北京市公安局服务器、操作系统、数据库、工作站采购项目_G25050中标人投标分项报价表（第1包）.pdf
8
sql-课件-第4章-SQL高级应用.ppt
9
北京市公安局服务器、操作系统、数据库、工作站采购项目_G25050中标人投标分项报价表（第2包）.pdf
10
《太极计算机股份有限公司2024年年度报告》.pdf
文档被以下合辑收录
相关文档
评论