MySQL maintenance - how to clear the buffer?
- by Dougal
We have a server running our web app (PHP / MySQL) which is SLOW.
My predecessor says that:
"We use to do database maintenance, which use to clear the buffer, cached and unwanted variables."
And I wonder what on earth he means with that statement? Does he mean a simple optimize of the tables? Or the query cache? I understand MySQL but don't really know what he is describing.
I would appreciate any pointers. Thanks.