This SQL script help keeping mythconverg database healthy:
OPTIMIZE TABLE archiveitems;
OPTIMIZE TABLE callsignnetworkmap;
OPTIMIZE TABLE capturecard;
OPTIMIZE TABLE cardinput;
OPTIMIZE TABLE channel;
OPTIMIZE TABLE channelgroup;
OPTIMIZE TABLE channelgroupnames;
OPTIMIZE TABLE channelscan;
OPTIMIZE TABLE channelscan_channel;
OPTIMIZE TABLE channelscan_dtv_multiplex;
OPTIMIZE TABLE codecparams;
OPTIMIZE TABLE credits;
OPTIMIZE TABLE customexample;
OPTIMIZE TABLE diseqc_config;
OPTIMIZE TABLE diseqc_tree;
OPTIMIZE TABLE displayprofilegroup;
OPTIMIZE TABLE displayprofiles;
OPTIMIZE TABLE dtv_multiplex;
OPTIMIZE TABLE dtv_privatetypes;
OPTIMIZE TABLE dvdbookmark;
OPTIMIZE TABLE dvdtranscode;
OPTIMIZE TABLE eit_cache;
OPTIMIZE TABLE filemarkup;
OPTIMIZE TABLE gallerymetadata;
OPTIMIZE TABLE gamemetadata;
OPTIMIZE TABLE gameplayers;
OPTIMIZE TABLE housekeeping;
OPTIMIZE TABLE inputgroup;
OPTIMIZE TABLE internetcontent;
OPTIMIZE TABLE internetcontentarticles;
OPTIMIZE TABLE inuseprograms;
OPTIMIZE TABLE jobqueue;
OPTIMIZE TABLE jumppoints;
OPTIMIZE TABLE keybindings;
OPTIMIZE TABLE keyword;
OPTIMIZE TABLE livestream;
OPTIMIZE TABLE logging;
OPTIMIZE TABLE movies_movies;
OPTIMIZE TABLE movies_showtimes;
OPTIMIZE TABLE movies_theaters;
OPTIMIZE TABLE music_albumart;
OPTIMIZE TABLE music_albums;
OPTIMIZE TABLE music_artists;
OPTIMIZE TABLE music_directories;
OPTIMIZE TABLE music_genres;
OPTIMIZE TABLE music_playlists;
OPTIMIZE TABLE music_smartplaylist_categories;
OPTIMIZE TABLE music_smartplaylist_items;
OPTIMIZE TABLE music_smartplaylists;
OPTIMIZE TABLE music_songs;
OPTIMIZE TABLE music_stats;
OPTIMIZE TABLE mythlog;
OPTIMIZE TABLE mythweb_sessions;
OPTIMIZE TABLE networkiconmap;
OPTIMIZE TABLE newssites;
OPTIMIZE TABLE oldfind;
OPTIMIZE TABLE oldprogram;
OPTIMIZE TABLE oldrecorded;
OPTIMIZE TABLE people;
OPTIMIZE TABLE phonecallhistory;
OPTIMIZE TABLE phonedirectory;
OPTIMIZE TABLE pidcache;
OPTIMIZE TABLE playgroup;
OPTIMIZE TABLE powerpriority;
OPTIMIZE TABLE profilegroups;
OPTIMIZE TABLE program;
OPTIMIZE TABLE programgenres;
OPTIMIZE TABLE programrating;
OPTIMIZE TABLE recgrouppassword;
OPTIMIZE TABLE record;
OPTIMIZE TABLE recorded;
OPTIMIZE TABLE recordedartwork;
OPTIMIZE TABLE recordedcredits;
OPTIMIZE TABLE recordedfile;
OPTIMIZE TABLE recordedmarkup;
OPTIMIZE TABLE recordedprogram;
OPTIMIZE TABLE recordedrating;
OPTIMIZE TABLE recordedseek;
OPTIMIZE TABLE recordfilter;
OPTIMIZE TABLE recordingprofiles;
OPTIMIZE TABLE recordmatch;
OPTIMIZE TABLE romdb;
OPTIMIZE TABLE schemalock;
OPTIMIZE TABLE settings;
OPTIMIZE TABLE storagegroup;
OPTIMIZE TABLE tvchain;
OPTIMIZE TABLE tvosdmenu;
OPTIMIZE TABLE upnpmedia;
OPTIMIZE TABLE videometadata_backup;
OPTIMIZE TABLE videocast;
OPTIMIZE TABLE videocategory;
OPTIMIZE TABLE videocollection;
OPTIMIZE TABLE videocountry;
OPTIMIZE TABLE videogenre;
OPTIMIZE TABLE videometadata;
OPTIMIZE TABLE videometadatacast;
OPTIMIZE TABLE videometadatacountry;
OPTIMIZE TABLE videometadatagenre;
OPTIMIZE TABLE videopathinfo;
OPTIMIZE TABLE videosource;
OPTIMIZE TABLE videotypes;
OPTIMIZE TABLE weatherdatalayout;
OPTIMIZE TABLE weatherscreens;
OPTIMIZE TABLE weathersourceettings;
OPTIMIZE TABLE websites;
ANALYZE TABLE archiveitems;
ANALYZE TABLE callsignnetworkmap;
ANALYZE TABLE capturecard;
ANALYZE TABLE cardinput;
ANALYZE TABLE channel;
ANALYZE TABLE channelgroup;
ANALYZE TABLE channelgroupnames;
ANALYZE TABLE channelscan;
ANALYZE TABLE channelscan_channel;
ANALYZE TABLE channelscan_dtv_multiplex;
ANALYZE TABLE codecparams;
ANALYZE TABLE credits;
ANALYZE TABLE customexample;
ANALYZE TABLE diseqc_config;
ANALYZE TABLE diseqc_tree;
ANALYZE TABLE displayprofilegroup;
ANALYZE TABLE displayprofiles;
ANALYZE TABLE dtv_multiplex;
ANALYZE TABLE dtv_privatetypes;
ANALYZE TABLE dvdbookmark;
ANALYZE TABLE dvdtranscode;
ANALYZE TABLE eit_cache;
ANALYZE TABLE filemarkup;
ANALYZE TABLE gallerymetadata;
ANALYZE TABLE gamemetadata;
ANALYZE TABLE gameplayers;
ANALYZE TABLE housekeeping;
ANALYZE TABLE inputgroup;
ANALYZE TABLE internetcontent;
ANALYZE TABLE internetcontentarticles;
ANALYZE TABLE inuseprograms;
ANALYZE TABLE jobqueue;
ANALYZE TABLE jumppoints;
ANALYZE TABLE keybindings;
ANALYZE TABLE keyword;
ANALYZE TABLE livestream;
ANALYZE TABLE logging;
ANALYZE TABLE movies_movies;
ANALYZE TABLE movies_showtimes;
ANALYZE TABLE movies_theaters;
ANALYZE TABLE music_albumart;
ANALYZE TABLE music_albums;
ANALYZE TABLE music_artists;
ANALYZE TABLE music_directories;
ANALYZE TABLE music_genres;
ANALYZE TABLE music_playlists;
ANALYZE TABLE music_smartplaylist_categories;
ANALYZE TABLE music_smartplaylist_items;
ANALYZE TABLE music_smartplaylists;
ANALYZE TABLE music_songs;
ANALYZE TABLE music_stats;
ANALYZE TABLE mythlog;
ANALYZE TABLE mythweb_sessions;
ANALYZE TABLE networkiconmap;
ANALYZE TABLE newssites;
ANALYZE TABLE oldfind;
ANALYZE TABLE oldprogram;
ANALYZE TABLE oldrecorded;
ANALYZE TABLE people;
ANALYZE TABLE phonecallhistory;
ANALYZE TABLE phonedirectory;
ANALYZE TABLE pidcache;
ANALYZE TABLE playgroup;
ANALYZE TABLE powerpriority;
ANALYZE TABLE profilegroups;
ANALYZE TABLE program;
ANALYZE TABLE programgenres;
ANALYZE TABLE programrating;
ANALYZE TABLE recgrouppassword;
ANALYZE TABLE record;
ANALYZE TABLE recorded;
ANALYZE TABLE recordedartwork;
ANALYZE TABLE recordedcredits;
ANALYZE TABLE recordedfile;
ANALYZE TABLE recordedmarkup;
ANALYZE TABLE recordedprogram;
ANALYZE TABLE recordedrating;
ANALYZE TABLE recordedseek;
ANALYZE TABLE recordfilter;
ANALYZE TABLE recordingprofiles;
ANALYZE TABLE recordmatch;
ANALYZE TABLE romdb;
ANALYZE TABLE schemalock;
ANALYZE TABLE settings;
ANALYZE TABLE storagegroup;
ANALYZE TABLE tvchain;
ANALYZE TABLE tvosdmenu;
ANALYZE TABLE upnpmedia;
ANALYZE TABLE videometadata_backup;
ANALYZE TABLE videocast;
ANALYZE TABLE videocategory;
ANALYZE TABLE videocollection;
ANALYZE TABLE videocountry;
ANALYZE TABLE videogenre;
ANALYZE TABLE videometadata;
ANALYZE TABLE videometadatacast;
ANALYZE TABLE videometadatacountry;
ANALYZE TABLE videometadatagenre;
ANALYZE TABLE videopathinfo;
ANALYZE TABLE videosource;
ANALYZE TABLE videotypes;
ANALYZE TABLE weatherdatalayout;
ANALYZE TABLE weatherscreens;
ANALYZE TABLE weathersourceettings;
ANALYZE TABLE websites;
