MySql monitoring & optimzing commands

Some of the terms used in the article below refer to

USERNAME = your username
MYSQL_PASSWORD = your password
DATABASE_1 = name of the database
LOCAL_DOMAIN.COM = local domain name
DESTINATION_DOMAIN.COM = remote domain name

Restart MySql Server

Check database size

Check if mysql needs any repairs on any database

Check if mysql needs any repairs on any database

Check specific mysql database

mysql database repair command on all databases

mysql database repair command on specific database

Command to optimize mysql databases

Login in mysql shell and execute the command to see current working mysql processes.

login to mysql and check mysql cache status.

If your host is blocked by too many connections. You can empty them by the command below.

Flush privileges

install database internal files

show all permissions for a users

Get number of Wordpres posts status

You can delete WordPress revisions by the follwing command.

Check query cache working

Get all cache related settings information.