mysql 通过查询log日志，调试sql

mysql进入命令行界面
mysql> show variables like '%log%';
| general_log                             | ON                                           |
| general_log_file                        | /usr/local/mysql/data/hd.log                 |
| slow_query_log                          | ON                                           |
| slow_query_log_file                     | /usr/local/mysql/data/hd-slow.log            |

mysql> set global general_log=on;

tailf /usr/local/mysql/data/hd.log                
看各种sql执行情况