MySQL Forums
Forum List  »  Optimizer & Parser

Flush
Posted by: Wayne Lee
Date: March 18, 2008 02:19AM

Hello All,
Recently I have been experiencing some slow web pages and I started to look at our DB, I decided it was probably a good idea to carry out some maintenance on the db, but I have some questions I was hoping somebody could help me with.

What consiquences do I face if I use any of the following
'OPTIMIZE TABLE table_name;'
'FLUSH HOSTS'
'FLUSH LOGS'
'FLUSH PRIVILEGES'
'FLUSH QUERY CACHE'
'FLUSH TABLES'
'FLUSH STATUS'
'FLUSH USER_RESOURCES'


I am trying to tune/cleanup our db but can't find much info on these commands other than how to run them.

Many Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Flush
5844
March 18, 2008 02:19AM
2481
March 18, 2008 04:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.