Wednesday, February 4, 2015

Mysqladmin flush commands

  All mysqladmin flush commands.

# mysqladmin -u root -ptmppassword flush-hosts 
 
# mysqladmin -u root -ptmppassword flush-logs 
 
# mysqladmin -u root -ptmppassword flush-privileges 
 
# mysqladmin -u root -ptmppassword flush-status 
 
# mysqladmin -u root -ptmppassword flush-tables 
 
# mysqladmin -u root -ptmppassword 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.

No comments:

Post a Comment