snipt

Ctrl+h for KB shortcuts

MySQL

show state & thread ID's of MySQL processes

SHOW PROCESSLIST;
https://snipt.net/embed/48249b7e42ff1283a6efb0212f0f78df/
/raw/48249b7e42ff1283a6efb0212f0f78df/
48249b7e42ff1283a6efb0212f0f78df
mysql
MySQL
1
2019-06-04T23:36:59
True
False
False
/api/public/snipt/1349/
show-state-thread-ids-of-mysql-processes
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">SHOW</span> <span class="n">PROCESSLIST</span><span class="p">;</span> </span></pre></div> </td></tr></table>
mysql, optimization