#!/bin/bash
#
# /usr/local/sbin/localmysqloptimize
# Copyright 2004 Jonas Smedegaard <dr@jones.dk>
#
# $Id: localmysqloptimize,v 1.1 2004-08-26 22:20:37 jonas Exp $
#
# MySQL maintenance script
#

# halt on errors
set -e

find /var/lib/mysql -type f -regex '.*\.MYI' -exec myisamchk -r --sort-index --analyze -s {} ';'