]>
code.delx.au - mediapc-tools/blob - mythtv-mysql-maintenance
3 echo "SELECT table_name FROM tables WHERE engine = 'MyISAM' AND table_schema = 'mythconverg'" | \
4 mysql
-s information_schema | \
5 awk '{print "REPAIR TABLE " $1 "; OPTIMIZE TABLE " $1 "; ANALYZE TABLE " $1 ";"}' | \
6 mysql
-s mythconverg | \
9 mysql
-s mythconverg
<<EOT
10 ALTER TABLE recordedseek ORDER BY chanid, starttime, type;
11 ALTER TABLE program ORDER BY starttime, chanid;
12 ALTER TABLE filemarkup ORDER BY filename;