Mysqladmin Practical Tools

The mysqladmin command-line utility is a heavyweight tool in the command-line tool suite. This tool can perform many options and tools (called commands).

Because this utility is run from the command line, it allows administrators to write a series of action scripts, which is much easier than running SQL commands directly. In fact, some third-party monitoring tools combine mysqladmin and SQL commands with utility to gather information and display it in other forms.

status

Briefly displays server status information, including uptime, number of threads, number of queries, and general statistics. This command provides a snapshot of the health status of the server.

Extended-status

Displays a complete list of system statistics, similar to the SQL SHOW Status command.

processlist

Displays a list of current processes, similar to the SQL show processlist command

Kill <thread Id>

Mysqladmin-uroot-pguiquanmaster processlist--sleep 3//Display process list 3s refresh once

Mysqladmin-uroot-pguiquanmaster extended-status--relative--sleep 3//View system variable previous value and current value

Mysqladmin Practical Tools