Here we can see some tips with mysqladmin tool
To check the status of mysqld
# mysqladmin -u root -pmysql ping
# service mysqld status
# mysqladmin -u root -pmysql status
To find mysql version
# mysqladmin -u root -pmysql version
To view all the MySQL
Server status variable and it s current value.
# mysqladmin -u root -pmysql extended-status
To display all MySQL
server system variables and the values
# mysqladmin -u root -pmysql variables
To display all the running process/queries in the mysql database.
# mysqladmin -u root -pmysql processlist
# mysqladmin -u root -pmysql processlist -i 1 ---- run this
command automatically every 1 second.
To create a DB
# mysqladmin -pmysql create DBtest
To Drop a DB
# mysqladmin -pmysql drop DBtest
To reload mysqld demon
# mysqladmin -pmysql reload
# mysqladmin -pmysql refrsh
To stop mysql daemon
# mysqladmin -pmysql shutdow
Note: You can also use /etc/rc.d/init.d/mysqld stop to shutdown
the server. To start the server, execute /etc/rc.d/init.d/mysql
start
Mysql flush
# mysqladmin -pmysql flush-hosts
# mysqladmin -pmysql flush-logs
# mysqladmin -pmysql flush-privileges
# mysqladmin -pmysql flush-status
# mysqladmin -pmysql flush-tables
# mysqladmin -pmysql flush-threads
flush-hosts: Flush all information in the host cache.
flush-privileges: Reload the grant tables (same as reload).
flush-status: Clear status variables.
flush-threads: Flush the thread cache.
To start and stop MySQL replication on a slave server
# mysqladmin -u root -pmysql stop-slave
# mysqladmin -u root -pmysql start-slave
No comments:
Post a Comment