Start the server with mysqladmin , by running the mysqld executable, or by using the Windows Services manager.
Shut down the server with mysql.server stop or mysqladmin shutdown .
Use mysqlshow or SHOW to get information about the current database or MySQL server.
Set variables with set variable=value; .
See threads with show processlist and kill them with kill processid .
Clear caches with FLUSH and RESET .
Improve the speed of joins with analyze table tablename ;.
MySQL stores log information in the error log, the query log (all queries), the binary log (queries that change data), and the slow query log (queries that take longer than long_query_time ).