Tutorial by Examples

Creating a database in MySQL CREATE DATABASE mydb; Return value: Query OK, 1 row affected (0.05 sec) Using the created database mydb USE mydb; Return value: Database Changed Creating a table in MySQL CREATE TABLE mytable ( id int unsigned NOT NULL auto_increme...

Processlist This will show all active & sleeping queries in that order then by how long. SELECT * FROM information_schema.PROCESSLIST ORDER BY INFO DESC, TIME DESC; This is a bit more detail on time-frames as it is in seconds by default SELECT ID, USER, HOST, DB, COMMAND, TIME as time_second...