We have a server running our PHP/MySQL-based web application which is SLOW.
My predecessor says:
We used to do database maintenance, which used 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.