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...

MySQL: Find all references to a table before moving it

Scenario You have to move a MySQL database table to another database, but you have many other tables, functions, routines, events etc. which access it. Before moving it, it is not enough to find only the tables containing foreign keys, but also find functions etc....
  [email protected]