One of MySQL Learning

Explain SQL statement: Query time consumed
Select version (): View MySQL version

Show profiles: Analyze SQL Performance

Set profiling = 1: Enable the profiles function, which is disabled by default.

Show profile for query x (x is query_id): view the detailed time consumption of a query based on query_id

Show profile block Io, CPU, memory, swaps, source, context switches for query x (x is query_id): View CPU usage, Io, and other information

 

1. Clear Cache

Reset query cache;

Flush tables;

2. view the table index:

Show index from table name;