[debian-mysql] Bug#432509: cron script to optimize databases

[Robert Millan]

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.

See attachment.

-- System Information:
Debian Release: 4.0
  APT prefers testing
  APT policy: (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-4-686
Locale: LANG=ca_ES.UTF-8, LC_CTYPE=ca_ES.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to ca_ES.UTF-8)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql-optimize-tables.cron.daily
Type: application/x-shellscript
Size: 234 bytes
Desc: not available
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20070710/adbe2552/attachment.bin