- 查看是否开启慢查询命令:show variables like ‘%slow%';
- 开启慢查询命令:set slow_query_log=’ON';
- 设置慢查询语句的时间命令:set global long_query_time=2;
- 查看当前运行的语句命令:show full processlist;
- 查看表的索引命令:show index FROM table_name;
- 创建索引目录:ALTER TABLE table_name ADD INDEX index_name (column_list);
- 查看执行计划命令:explain SELECT * FROM table_name where id = 10000;
- 查看某个数据库所有表的记录数:use information_schema; select table_name,table_rows from tables where TABLE_SCHEMA = ‘dbname';
- 启动mysql:service mysqld start (5.0版本是mysqld);service mysql start (5.5.7版本是mysql)
- 查看mysql的bin-log日志:show binary logs;
- 清理mysql的bin-log日志:如,清理mysql-bin.000018之前的日志:purge binary logs to ‘mysql-bin.000018′;
更多文章请移步到我的新博客:http://blog.haoitsoft.com