Some hand commands if you need to improve some SQL Queries:
analyze query:
1 | explain select .. from TABLE; |
show index:
1 | show index from TABLE; |
analyze table:
1 | analyze table TABLE; |
sql query without cache:
1 | select SQL_NO_CACHE .. from TABLE; |
show mysql cache status:
1 | SHOW VARIABLES LIKE ‘query_cache%’; |
