MySQL Common sql

SHOW STATUS like ' uptime ' start time

SHOW STATUS like ' com_select ' total number of queries

SHOW STATUS like ' com_update ' total number of modifications

SHOW global STATUS like ' connections ' link number does not add GLOBAL to current session

DOS command Netstat-an query port monitoring

NETSTAT-ANB View Process Number

Slow query default more than 10 seconds for slow query

Show STATUS like ' slow_queries ' view slow queries (including additions, deletions, stored procedures, functions)

SHOW VARIABLES default time for like ' long_query_time ' slow query

Set Long_query_time = 1 Sets the default time unit for slow query s

Query index

Show index from table

Show keys from table

MySQL Common sql