MySQL 命令

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   打开