MySQL數(shù)據(jù)庫巡檢手冊

《MySQL數(shù)據(jù)庫巡檢手冊》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。

1、MySQL"?LinuxX￥oE
Yd/W?X￥I/Dà%X￥
???v5u¨jX￥
@×?X￥
d/±3?I/?bX￥
243?
O6ó,￥edmidecode

2、grep"ProductName"CPUcat/proc/cpuinfo

3、grepname

4、cut-f2-d:

5、uniq-cQfree-m?df-h<|ifcon?g-a′6ouname-a
 CPUè2topCPU.xè2580%CPU°JuptimeCPU°JT510Qè2free-mQf2580%Q

6、swapf2free-mswapf2510%?f2df-ah?f2580%?°Jiostat-xkd1utilT10%Qo;Vnetstat–an

7、grepLISTEN?~i?5X
V?$D
V?D?<|FNiftop<|FN5Lμ
50%Iàpsaux

8、moreD?è?
$I Iàps-ef

9、grepmysqldàportdatadirg?`4selectversion()M?àdu-sh.g?wMCàshowtablestatusà?!
RowsòData_lengthz?RowsT510000000/:?sh

10、owvariableslike'%log_error%';2K?ERROR
?showvariableslike'%slow%';à??????à2K
}cEygàbacklog,￥§T^_à.max_allowed_packetyg?§R>óinteractive_timeoutwait_timeoutskip_name_resolvemax_connectionslog_binexpire_logs_daysopen_?le_limittable_open_cachethread_cache_sizesort_buffer_sizejoin_bu

11、ffer_sizeinnodb_buffer_pool_sizeinnodb_?le_per_tableinnodb_open_?lesinnodb_thread_concurrencyinnodb_?ush_log_at_commitinnodb_log_buffer_sizeinnodb_log_?le_sizeinnodb_log_?les_in_groupgeneral_loglog_errorslow_query_loglong_query_timeQPSà3áo/showstatuslike‘queries’P*(
3á3'￠?nqQPS{Bàshowstatusl

12、ike‘com_%’H_com_select×{H_com_insert;com_update;com_deletePn{
H_g?q{B?ó=7rUgàshowstatuslikeZg?~=7
rUg?T]‘%Threads_connected%’5max_connectionsórUgàshowstatuslike?max_used_connections1['%max_used_connections%';max_connections?¤^max_connectionsshowvariableslike'%max_connections%';·rUàshow

13、variableslike‘%Aborted%’àAborted_clientsAborted_connects?A Sx?showglobalstatuslikeZT510?)-?1S'%threads_running%';g&?}cóxéíàshowstatuslikethreads_created/connections é'%threads_created%';t

14、2??Z+?¤^thread_cache_sizeóshowstatuslike'connections';d/x±?showfullprocesslist;=7Sx

15、?±AInnoDBBufferPoolàshowstatuslikeInnodb_buffer_pool_reads/'Innodb_buffer_pool_read_requesInnodb_buffer_pool_read_requestts';s ét

16、2??Z+?¤^showstatuslikeinnodb_buffer_pool_sizeó‘Innodb_buffer_pool_reads';ì0sàshowfullprocesslist;àsta