title: MySQL - how to SHOW PROCESSLIST only with current user's processes?
body: <p>Is there a way in MySQL 5 to show only the current user's processes(queries)?</p>
  
  <p>The user has the <code>PROCESS</code> privilege, therefore <code>SHOW PROCESSLIST</code> displays running processes of all users. According to the documentation, <code>SHOW PROCESSLIST</code> does not allow any kind of <code>WHERE</code> syntax, nor did I manage to make it into a subquery.</p>
  
  <p>Of course, I could simply send the query, e.g. in a PHP script, and go through the results in a loop, discarding everything that's not mine, but it seems rather inefficient. Changing the user privileges is not feasible.</p>
  
  <p>Are there any other ways? Thanks in advance.</p>