MySQL is the world\’s most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout it\’s history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice Read More …
is a real-time query performance and diagnostics tool for the MySQL database server. It\’s core features: Query, table and user performance Graphical visualisation Low overhead User friendly
How to find and remove duplicates.
How to drop multiple tables named with prefix (or named with similar pattern).
How to delete related records with one query (using ON DELETE CASCADE foreign key).
How to delete records from multiple tables with one query.
How to select latest one from each category (group-wise max in a group query)
How to rank records (grouped ranking).
Custom ordering (order rows by my order).
Example shows how to rank records in a table.