时间:2021-07-01 10:21:17 帮助过:2人阅读
- select @@session.read_buffer_size; <span style="color: #008000">#</span><span style="color: #008000">基于当前session查看当前参数的有效性</span>
- show variables like ‘log_error‘; <span style="color: #008000">#</span><span style="color: #008000">查看错误日志文件的路径和文件名</span>
- show variables like ‘%slow%‘; <span style="color: #008000">#</span><span style="color: #008000">查看慢查询日志相关变量</span>
- <span style="color: #000000">
- show variables like </span>‘slow_query_log‘; <span style="color: #008000">#</span><span style="color: #008000">慢查询日志开关</span>
- <span style="color: #000000">
- show variables like </span>‘slow_query_log_file‘; <span style="color: #008000">#</span><span style="color: #008000">慢查询日志文件</span>
- <span style="color: #000000">
- show variables like </span>‘long_query_time‘; <span style="color: #008000">#</span><span style="color: #008000">慢查询日志时间 <br><br><span style="color: #333333">set global slow_query_log = on; <span style="color: #339966">#打开慢查询日志</span><br>set @@session.long_query_time=3; <br>set @@global.long_query_time=3; <br><br>show variables like ‘log_output‘; <span style="color: #339966">#查看慢日志输出格式</span><br></span><br><br></span>
MySQL 命令
标签:参数 blog mysql glob put 文件 lob output 打开