Shulou(Shulou.com)06/01 Report--

1) enter the mysql terminal # mysql-uroot-p

2) View the version # mysqladmin-uroot-p version

Select @ @ version

3) list the database show databases

4) show which threads are running show processlist

5) View the configuration # cat / etc/my.cnf

6) View engine > show engines

Default engine

Show variables like'% storage_engine%'

7) query log show variables like 'log_%'

# cat / etc/my.cnf | grep log

Log-bin=mysql-bin

Binlog_format=mixed

Log-error=/var/log/mysqld.log

# tail-n 20 / var/log/mysqld.log

8) View all library sizes select concat (round (sum (DATA_LENGTH/1024/1024) + sum (INDEX_LENGTH/1024/1024), 2), 'MB') as data from information_schema.tables all library sizes

Select TABLE_SCHEMA, concat (truncate (sum (data_length) / 1024 index_length), 'MB') as data_size,concat (truncate (sum (index_length) / 1024 index_length),' MB') as index_size from information_schema.tables group by TABLE_SCHEMA order by data_length desc; specifies the size of all tables in the library

Select TABLE_NAME, concat (truncate (data_length/1024,2), 'KB') as data_size, concat (truncate (index_length/1024,2),' KB') as index_size from information_schema.tables where TABLE_SCHEMA = 'mysql' group by TABLE_NAME order by data_length desc

9) query table lock statistics show status like 'table%'

If the waited value is high, lock contention is serious.

10) check key efficiency show status like 'key_read%'

Key_reads/key_read_requests is as low as possible, at least 1RV 100, preferably 1RV 1000

11) check that the request cache hits show status like 'Qcache%'

The Qcache_lowmem_ prunes value is very large, indicating that the buffer is not enough.

The Qcache_hits is very large, indicating that the query buffer is used frequently and needs to be increased.

12) determine whether master and slave show global status like 'Slave_running'

13) temporary table show status like'% tmp%'

Normal created_tmp_disk_tables/created_tmp_tables*100%

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.