不知道是关键字不对,还是数据太少,在百度没查到。教程开启慢查询是如此这般。
mysqld.exe --safe-mode --slow-query-log.
不是WAMP环境。在我的MYSQL\BIN目录下,只有 mysql.exe mysqld-nt.exe 和mysqldump.exe
WAMP开启还有意外之处?
mysqld.exe --safe-mode --slow-query-log.
不是WAMP环境。在我的MYSQL\BIN目录下,只有 mysql.exe mysqld-nt.exe 和mysqldump.exe
WAMP开启还有意外之处?
bin\mysqld-nt.exe: unknown option '--slow-query-log'
mysql> show variables like 'log_%';
+---------------------------------+--------------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------------+
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | d:\wamp\logs\mysql\mysql_log_err.txt |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | ON |
| log_warnings | 1 |
+---------------------------------+--------------------------------------+
7 rows in set (0.00 sec)
set-variable = log_slow_queries=c:\slow_sql.log
set-variable = slow_launch_time=1试试
set-variable = long_query_time=10
这句话是什么意思?