MySQL FLUSH Commands.
By InterServer Staff on October 23rd, 2015
Flush privileges
mysql> FLUSH PRIVILEGES;
when we grant some privileges for a user, running the command flush privileges will reloads the grant tables in the mysql database enabling the changes to take effect without reloading or restarting mysql service.
Flush TABLES
mysql> FLUSH TABLES;
The command closes all tables which are currently open or in use. And clears cache which intern make better utilization on available memory.
Flush HOSTS
mysql> FLUSH HOSTS;
The command uses host cache tables, if maximum number of connections has been reached for a particular host, mysql server will not able to make new connections. flushing host tables resets the process and again allows the connections for particular HOST.
Flush LOGS
mysql> FLUSH LOGS;
The command closes and reopens all log files, if log files are to big and taking more time to load then you can run the command which will create an empty log file.
ok
cool
Can’t read times.co.sz
Hello,
Greetings from InterServer>
Could you please share us more information on steps to replicate the error with MySQL flush?
Did you mean times.co.sz finding some other technical issue? Please feel free to reach our support through Live chat or email.
Have a great day.
very informative