From b3cc80322d2aa7deb533ba5d6f2698f2608d4f80 Mon Sep 17 00:00:00 2001
From: Jonas Smedegaard <dr@jones.dk>
Date: Thu, 26 Aug 2004 22:20:37 +0000
Subject: New command localmysqloptimize: Run myisamchk on all databases.

---
 localmysqloptimize | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100755 localmysqloptimize

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 {} ';'
-- 
cgit v1.2.3