From 5d18bd54fd59cfb670fe2d14dc00890e4e339d81 Mon Sep 17 00:00:00 2001
From: James Bunton <jamesbunton@delx.net.au>
Date: Sun, 25 Mar 2018 00:22:09 +0000
Subject: [PATCH] mythtv-mysql-maintenance

---
 mythtv-mysql-maintenance | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100755 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
-- 
2.39.2