From: James Bunton <jamesbunton@delx.net.au>
Date: Sun, 25 Mar 2018 00:22:09 +0000 (+0000)
Subject: mythtv-mysql-maintenance
X-Git-Url: https://code.delx.au/mediapc-tools/commitdiff_plain/5d18bd54fd59cfb670fe2d14dc00890e4e339d81

mythtv-mysql-maintenance
---

diff --git a/mythtv-mysql-maintenance b/mythtv-mysql-maintenance
new file mode 100755
index 0000000..82d1c2f
--- /dev/null
+++ b/mythtv-mysql-maintenance
@@ -0,0 +1,15 @@
+#!/bin/bash
+
+echo "SELECT table_name FROM tables WHERE engine = 'MyISAM' AND table_schema = 'mythconverg'" | \
+    mysql -s information_schema | \
+    awk '{print "REPAIR TABLE " $1 "; OPTIMIZE TABLE " $1 "; ANALYZE TABLE " $1 ";"}' | \
+    mysql -s mythconverg | \
+    grep -i error
+
+mysql -s mythconverg <<EOT
+ALTER TABLE recordedseek ORDER BY chanid, starttime, type;
+ALTER TABLE program ORDER BY starttime, chanid;
+ALTER TABLE filemarkup ORDER BY filename;
+EOT
+
+exit 0