3
文檔 /
MySQL數據庫巡檢手冊
MySQL數據庫巡檢手冊
5墨值下載
MySQL
Linux
24
dmidecode | grep "Product Name"
CPU
cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -c
free -m
df -h
ifcon?g -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_?le_limit
table_open_cache
thread_cache_size
sort_buffer_size
join_buffer_size
innodb_buffer_pool_size
innodb_?le_per_table
innodb_open_?les
innodb_thread_concurrency
innodb_?ush_log_at_commit
innodb_log_buffer_size
innodb_log_?le_size
innodb_log_?les_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
5墨值下載
【版權聲明】本文為墨天輪用戶原創內容，轉載時必須標注文檔的來源（墨天輪），文檔鏈接，文檔作者等基本信息，否則作者和墨天輪有權追究責任。如果您發現墨天輪中有涉嫌抄襲或者侵權的內容，歡迎發送郵件至：contact@modb.pro進行舉報，并提供相關證據，一經查實，墨天輪將立刻刪除相關內容。
下載排行榜
文檔被以下合輯收錄
評論