mytop

Monitor MySQL queries

$ mytop

$ mytop -u [user] -p [password] -d [database]

$ mytop -h [hostname] -u [user] -p [password]

$ mytop -s [5]

$ mytop -i

$ mytop --delay [3]

mytop [-u user] [-p pass] [-h host] [-d database] [options]

mytop displays MySQL server activity in real-time, similar to top for processes. It shows running queries, connections, and server statistics.
The display includes query threads with their states, execution times, and SQL text. Long-running queries stand out for attention.
Server statistics show queries per second, slow queries, threads connected, and cache hit rates. These metrics help identify performance issues.
Slow query mode filters display to queries exceeding a time threshold. This focuses attention on problematic operations.
The kill command terminates runaway queries. Combined with filtering, it helps manage query overload situations.
Connection to remote servers enables monitoring multiple databases from one location.

-u USER

MySQL username.

MySQL password.

MySQL server hostname.

Default database.

MySQL port.

Slow query threshold.

Show idle connections.

Refresh interval.

Use ANSI color.

Batch mode (no updates).

q

Quit.

Kill a query/thread.

Toggle full query display.

Change sort column.

Reverse sort order.

Pause display.

Help.

Requires MySQL PROCESS privilege. Some features need SUPER privilege. Not actively maintained - consider alternatives like innotop. May not support all MariaDB features.

mytop was written by Jeremy Zawodny around 2000 when he worked at Yahoo. It became a standard tool for MySQL administrators, filling the gap for real-time server monitoring before such features were built into management tools.

innotop(1), mysql(1), mysqladmin(1), pt-query-digest(1)