What are the operations of daily maintenance of mysql

The following mainly brings you what are the operations of mysql daily maintenance, and I hope these contents can bring you practical use, which is also the main purpose of this article when I edit mysql daily maintenance. All right, don't talk too much nonsense, let's just read the following.

View the MySQL running process

Mysql > show processlist

Check the operation of the Innodb engine:

Mysql > show engine innodb status\ G

Check the MySQL parameters:

Mysql > show [global] variables like'% innodb%'

View the running status of MySQL:

Mysql > show [global] status like'% thread%'

View tables, stored procedures, triggers:

Mysql > show tables

Mysql > show procedure status; show create procedure USP_Cursor

Mysql > show triggers; show create trigger TRI_UP_User_Delete

View the MySQL help:

Mysql > help

Mysql > help conntents

Mysql > help show

For the above about the daily maintenance of mysql what operations, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.