Am i right in think flush is a good thing and it simply refeshes
everything?.

ie. if i have deleted lots and tables, data and users etc in the past few
months.

Is it ful if i do a flush /All to 'refresh mysql?

Or is my understanding of the flush term incorrect?

tia

== Quote from Peter (me@privacy.net)'s article
> Am i right in think flush is a good thing and it simply refeshes
> everything?.
> ie. if i have deleted lots and tables, data and users etc in the past few
> months.
> Is it ful if i do a flush /All to 'refresh mysql?
> Or is my understanding of the flush term incorrect?
> tia

no, flush refreshes what's in memory such as user name and passwords that mysql
loads up at startup.

what you're thinking is a reorg which is accomplished by doing an optimize
(usually local).
--
POST BY: lark with PHP News Reader ;o)