diff options
Diffstat (limited to 'localmysqloptimize')
-rwxr-xr-x | localmysqloptimize | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/localmysqloptimize b/localmysqloptimize new file mode 100755 index 0000000..f18027b --- /dev/null +++ b/localmysqloptimize @@ -0,0 +1,14 @@ +#!/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 {} ';' |