MySQL

Cari MySQL Process List & Kill Process id

Simple Solution

  1. Login DB (plesk db / mysql)
  2. Cari process list (show full processlist;)
  3. Kill process (KILL <pid>;)

Advanced Solution

  1. Login DB
  2. Run query => Select concat('KILL ',id,';') from information_schema.processlist where user='user';
  3. Copy query result, paste dan remove pipe | sign, copy & paste all lagi ke query console. HIT ENTER.

Leave a Reply

Your email address will not be published. Required fields are marked *