MySQL Optimization common statements

Show status;//query mysql various states;

Show variables like ' long_query_time ';//limited time for slow queries

Set long_query_time=1;//Setting the limit time for slow queries

Show global status like ' slow_queries ';//execute a few slow queries

Show global status like ' Com_select ';//How many query operations the database has performed from start to now

Show status like ' Com_insert ';//The number of times the insert operation is performed under the current session of the database

Delimiter $$ Modify command end prompt

MySQL Optimization common statements