MySQL数据库巡检手册

《MySQL数据库巡检手册》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、MySQL"¬LinuxX¥oE
Yd/WÖX¥I/ÐÀ%X¥
¾ÅÖv5u¨jX¥
@×ÃX¥
d/±³ÖI/ÖbX¥
243¡
O6Ó,¥edmidecode

2、grep"ProductName"CPUcat/proc/cpuinfo

3、grepname

4、cut-f2-d:

5、uniq-cQfree-mÑdf-h<¦ifconfig-a´6ouname-a
 CPUȲtopCPU.xȲ580%CPU°JuptimeCPU°JT510QȲfree-mQf²580%Q

6、swapf²free-mswapf²510%Ñf²df-ahÑf²580%Ñ°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_file_limittable_open_cachethread_cache_sizesort_buffer_sizejoin_bu

11、ffer_sizeinnodb_buffer_pool_sizeinnodb_file_per_tableinnodb_open_filesinnodb_thread_concurrencyinnodb_flush_log_at_commitinnodb_log_buffer_sizeinnodb_log_file_sizeinnodb_log_files_in_groupgeneral_loglog_errorslow_query_loglong_query_timeQPSÀ3Áº/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_connections¹['%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、²Ö®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、²Ö®Z+Ö¤^showstatuslikeinnodb_buffer_pool_sizeÓ‘Innodb_buffer_pool_reads';Ì0sÀshowfullprocesslist;Àsta