1、MySQL “LinuxXoEYd/WXI/%Xv5ujXXd/I/ bX 24 3O6 ,edmidecode | grep “Product Name“CPU cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -cQfree -mdf -hQPS3/show status like queriesP*(33nqQPSBshow status like com_%H_com_selectH_com_insert; com_update;com_deletePnH_gqB=7rUgshow status like %Threads_conne
2、cted%Zg =7rUgT5max_connections rUgshow status like %max_used_connections%;show variables like %max_connections%;max_used_connectionsmax_connections max_connectionsrUshow variables like %Aborted%Aborted_clientsAborted_connectsASxshow global status like %threads_running%;ZT510)- 1Sgshow status like co
3、nnections;threads_created/connections t| Z+ thread_cache_sized/xshow full processlist; =7SxAInnoDB Buffer Poolshow status like Innodb_buffer_pool_read_requests;show status like Innodb_buffer_pool_reads;Innodb_buffer_pool_reads/Innodb_buffer_pool_read_requests t| Z+ innodb_buffer_pool_size0sshow full
4、 processlist;statewait for xxx lock)-0sInnoDB9show engine innodb status; LATEST DETECTED DEADLOCK)-G?TcInnoDB8#show engine innodb status;TRANSACTIONSACTIVE38#)-DlCshow global status like %opened_tables%;show variables like %table_open_cache%;opened_tables table_open_cacheshow variables like %query_cache% query cacheCshow global status like %tmp%;)-Created_tmp_tablesCreated_tmp_disk_tablesmkCreated_tmp_files+hhGroup By0binlogshow variables like log-binashow slave status; xApp4Ap2K
