snipt

Ctrl+h for KB shortcuts

INI

Enable Slow Query Logging

1
2
3
log-slow-queries = /var/log/mysqld.slow.log
long_query_time = 1
log-queries-not-using-indexes
https://snipt.net/embed/1208d3afaf5700bd650dc28f27339d8b/
/raw/1208d3afaf5700bd650dc28f27339d8b/
1208d3afaf5700bd650dc28f27339d8b
ini
INI
3
2019-06-16T15:02:34
True
False
False
Oct 24, 2012 at 01:40 PM
/api/public/snipt/49007/
enable-slow-query-logging
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="na">log-slow-queries</span> <span class="o">=</span> <span class="s">/var/log/mysqld.slow.log</span> </span><span id="L-2"><a name="L-2"></a><span class="na">long_query_time</span> <span class="o">=</span> <span class="s">1</span> </span><span id="L-3"><a name="L-3"></a><span class="err">log-queries-not-using-indexes</span> </span></pre></div> </td></tr></table>
mysqld