欢迎来到天天文库
浏览记录
ID:44165181
大小:175.07 KB
页数:3页
时间:2019-10-19
《MySQL数据库巡检手册》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、MySQL"¬LinuxX¥oEYd/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¼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_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 ~=7rUgÖ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
此文档下载收益归作者所有