資源描述:
《MySQL數(shù)據(jù)庫(kù)巡檢手冊(cè)》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫(kù)。
1、MySQL"?LinuxX¥oEYd/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?5XV?$DV?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?~=7rUg?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