MySQL FLUSH Commands.

By 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.

6 Responses to “MySQL FLUSH Commands.”

  1. Kitty says:
    June 23, 2020 at 6:12 am

    ok

    Reply
  2. Super Awesome Guy says:
    July 2, 2020 at 8:51 pm

    cool

    Reply
  3. JJoel Mfanukhona has says:
    July 20, 2020 at 2:44 pm

    Can’t read times.co.sz

    Reply
    • Athul Sudarshan says:
      August 14, 2020 at 10:54 pm

      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.

      Reply
  4. Saran says:
    September 20, 2020 at 5:55 am

    very informative

    Reply
  5. yoshi says:
    January 6, 2021 at 8:03 pm

    nice

    Reply

Leave a Reply