MySQL: Kill all queries / processes of certain user

Open your MySQL client or phpMyAdmin etc. Execute query: MySQL select concat('KILL ',id,';') from information_schema.processlist where user='yourUser' 1 select concat('KILL ',id,';') from information_schema.processlist where user='yourUser' Copy the result lines and...

Basic hints for MySQL performance optimization using Indexes

Problem An SQL query containing multiple table joins, functions etc. is too slow, but necessary. Solution approaches Indexes created on single or multiple MySQL table columns can increase performance in a significant way if they are used correctly. First, have a look...
  [email protected]