code.delx.au - mediapc-tools/blob - mythtv-mysql-maintenance

   1 #!/bin/bash
   2
   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 | \
   7     grep -i error
   8
   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;
  13 EOT
  14
  15 exit 0