Bill Shupp wrote:
Mick wrote:
Bill Shupp wrote:
Thanks for the tip, I'll put it in a shell script, and make a note
of it
on the site.
This is done. See http://shupp.org/ for details.
Regards,
Bill Shupp
I would suggest to optimize the table. That is why I added "OPTIMIZE
TABLE relaytofrom".
You run that query in addition? Or as part of the delete query?
Regards,
Bill
If you want to do that, do it nightly or weekly, or even monthly. An
OPTIMIZE TABLE locks the table till it is completed and "would not work
so goodly" in a high load environment.
Just my $0.02
My greylist table before an Optimize
records Size Overhead
relaytofrom 27,714 MyISAM 18.0 MB 7,020 KB
after an Optimize
relaytofrom 27,717 MyISAM 4.9 MB 0 KB
The Optimize took approx 2.3 seconds to run.
I've never run an Optimize on it before so that's a year of queries or
so on a moderately busy server.
Rick
