[debian-mysql] Bug#432509: closed by Christian Hammers <ch at debian.org> (Re: Bug#432509: cron script to optimize databases)

[Robert Millan]

On Mon, Sep 03, 2007 at 09:42:03PM +0000, Debian Bug Tracking System wrote:
> On 2007-07-10 Robert Millan wrote:
> > Package: mysql-client
> > Severity: wishlist
> > Tags: patch
> > 
> > I think a cron script to optimize databases would be useful.  There's a
> > significant performance penalty for database fragmentation, and periodic
> > optimization runs seem to be the only solution.
> 
> Too many people have several GB of data so such a script would take (i.e.
> block access to those tables) much too long and can thus never be installed
> by default.

Ok

> An example script seen unnecessary, too, as "mysqlcheck -o -A" is all you
> need!

Nice, thank you for the tip.

-- 
Robert Millan

<GPLv2> I know my rights; I want my phone call!
<DRM> What use is a phone call, if you are unable to speak?
(as seen on /.)