New command localmysqloptimize: Run myisamchk on all databases.

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 {} ';'