On Mon, 7 Jan 2019 14:25:11 +0000, you wrote:
>How big are peoples databases currently running...
I have a monster database. So increasing the size of the recordedseek
table would have a big impact on me:
root@mypvr:/var/lib/mysql# du -h mythconverg
14G mythconverg
root@mypvr:/var/lib/mysql# du -h mythconverg/*
4.0K mythconverg/archiveitems.frm
0 mythconverg/archiveitems.MYD
4.0K mythconverg/archiveitems.MYI
16K mythconverg/bdbookmark.frm
0 mythconverg/bdbookmark.MYD
4.0K mythconverg/bdbookmark.MYI
4.0K mythconverg/callsignnetworkmap.frm
0 mythconverg/callsignnetworkmap.MYD
4.0K mythconverg/callsignnetworkmap.MYI
8.0K mythconverg/capturecard.frm
8.0K mythconverg/capturecard.MYD
4.0K mythconverg/capturecard.MYI
4.0K mythconverg/cardinput.frm
0 mythconverg/cardinput.MYD
4.0K mythconverg/cardinput.MYI
8.0K mythconverg/channel.frm
4.0K mythconverg/channelgroup.frm
4.0K mythconverg/channelgroup.MYD
4.0K mythconverg/channelgroup.MYI
4.0K mythconverg/channelgroupnames.frm
4.0K mythconverg/channelgroupnames.MYD
4.0K mythconverg/channelgroupnames.MYI
36K mythconverg/channel.MYD
32K mythconverg/channel.MYI
8.0K mythconverg/channel_new.frm
4.0K mythconverg/channel_new.MYD
12K mythconverg/channel_new.MYI
4.0K mythconverg/channelscan_channel.frm
4.0K mythconverg/channelscan_channel.MYD
4.0K mythconverg/channelscan_channel.MYI
4.0K mythconverg/channelscan_dtv_multiplex.frm
4.0K mythconverg/channelscan_dtv_multiplex.MYD
4.0K mythconverg/channelscan_dtv_multiplex.MYI
4.0K mythconverg/channelscan.frm
4.0K mythconverg/channelscan.MYD
4.0K mythconverg/channelscan.MYI
4.0K mythconverg/codecparams.frm
8.0K mythconverg/codecparams.MYD
8.0K mythconverg/codecparams.MYI
4.0K mythconverg/crashed_names.frm
96K mythconverg/crashed_names.ibd
4.0K mythconverg/credits.frm
0 mythconverg/credits.MYD
4.0K mythconverg/credits.MYI
60K mythconverg/customexample.frm
4.0K mythconverg/customexample.MYD
4.0K mythconverg/customexample.MYI
4.0K mythconverg/db.opt
4.0K mythconverg/diseqc_config.frm
0 mythconverg/diseqc_config.MYD
4.0K mythconverg/diseqc_config.MYI
4.0K mythconverg/diseqc_tree.frm
4.0K mythconverg/diseqc_tree.MYD
4.0K mythconverg/diseqc_tree.MYI
4.0K mythconverg/displayprofilegroups.frm
4.0K mythconverg/displayprofilegroups.MYD
8.0K mythconverg/displayprofilegroups.MYI
4.0K mythconverg/displayprofiles.frm
16K mythconverg/displayprofiles.MYD
24K mythconverg/displayprofiles.MYI
4.0K mythconverg/dtv_multiplex.frm
4.0K mythconverg/dtv_multiplex.MYD
4.0K mythconverg/dtv_multiplex.MYI
4.0K mythconverg/dtv_privatetypes.frm
4.0K mythconverg/dtv_privatetypes.MYD
4.0K mythconverg/dtv_privatetypes.MYI
8.0K mythconverg/dvdbookmark.frm
76K mythconverg/dvdbookmark.MYD
8.0K mythconverg/dvdbookmark.MYI
4.0K mythconverg/dvdinput.frm
4.0K mythconverg/dvdinput.MYD
4.0K mythconverg/dvdinput.MYI
4.0K mythconverg/dvdtranscode.frm
4.0K mythconverg/dvdtranscode.MYD
4.0K mythconverg/dvdtranscode.MYI
4.0K mythconverg/eit_cache.frm
28K mythconverg/eit_cache.MYD
28K mythconverg/eit_cache.MYI
4.0K mythconverg/filemarkup.frm
400K mythconverg/filemarkup.MYD
328K mythconverg/filemarkup.MYI
4.0K mythconverg/gallery_directories.frm
0 mythconverg/gallery_directories.MYD
4.0K mythconverg/gallery_directories.MYI
8.0K mythconverg/gallery_files.frm
15M mythconverg/gallery_files.MYD
1.6M mythconverg/gallery_files.MYI
4.0K mythconverg/gallerymetadata.frm
4.0K mythconverg/gallerymetadata.MYD
8.0K mythconverg/gallerymetadata.MYI
12K mythconverg/gamemetadata.frm
0 mythconverg/gamemetadata.MYD
4.0K mythconverg/gamemetadata.MYI
8.0K mythconverg/gameplayers.frm
0 mythconverg/gameplayers.MYD
4.0K mythconverg/gameplayers.MYI
4.0K mythconverg/housekeeping.frm
4.0K mythconverg/housekeeping.MYD
4.0K mythconverg/housekeeping.MYI
4.0K mythconverg/inputgroup.frm
4.0K mythconverg/inputgroup.MYD
4.0K mythconverg/inputgroup.MYI
8.0K mythconverg/internetcontentarticles.frm
0 mythconverg/internetcontentarticles.MYD
4.0K mythconverg/internetcontentarticles.MYI
4.0K mythconverg/internetcontent.frm
0 mythconverg/internetcontent.MYD
4.0K mythconverg/internetcontent.MYI
4.0K mythconverg/inuseprograms.frm
4.0K mythconverg/inuseprograms.MYD
8.0K mythconverg/inuseprograms.MYI
4.0K mythconverg/iptv_channel.frm
16K mythconverg/iptv_channel.MYD
4.0K mythconverg/iptv_channel.MYI
4.0K mythconverg/jobqueue.frm
0 mythconverg/jobqueue.MYD
4.0K mythconverg/jobqueue.MYI
4.0K mythconverg/jumppoints.frm
8.0K mythconverg/jumppoints.MYD
8.0K mythconverg/jumppoints.MYI
4.0K mythconverg/keybindings.frm
60K mythconverg/keybindings.MYD
24K mythconverg/keybindings.MYI
4.0K mythconverg/keyword.frm
12K mythconverg/keyword.MYD
16K mythconverg/keyword.MYI
12K mythconverg/livestream.frm
0 mythconverg/livestream.MYD
4.0K mythconverg/livestream.MYI
12K mythconverg/logging.frm
0 mythconverg/logging.MYD
4.0K mythconverg/logging.MYI
4.0K mythconverg/movies_movies.frm
0 mythconverg/movies_movies.MYD
4.0K mythconverg/movies_movies.MYI
4.0K mythconverg/movies_showtimes.frm
0 mythconverg/movies_showtimes.MYD
4.0K mythconverg/movies_showtimes.MYI
4.0K mythconverg/movies_theaters.frm
0 mythconverg/movies_theaters.MYD
4.0K mythconverg/movies_theaters.MYI
4.0K mythconverg/music_albumart.frm
4.0K mythconverg/music_albumart.MYD
4.0K mythconverg/music_albumart.MYI
4.0K mythconverg/music_albums.frm
4.0K mythconverg/music_albums.MYD
12K mythconverg/music_albums.MYI
4.0K mythconverg/music_artists.frm
4.0K mythconverg/music_artists.MYD
12K mythconverg/music_artists.MYI
4.0K mythconverg/music_directories.frm
4.0K mythconverg/music_directories.MYD
4.0K mythconverg/music_directories.MYI
4.0K mythconverg/music_genres.frm
4.0K mythconverg/music_genres.MYD
12K mythconverg/music_genres.MYI
4.0K mythconverg/music_playlists.frm
4.0K mythconverg/music_playlists.MYD
4.0K mythconverg/music_playlists.MYI
12K mythconverg/music_radios.frm
128K mythconverg/music_radios.ibd
4.0K mythconverg/music_smartplaylist_categories.frm
4.0K mythconverg/music_smartplaylist_categories.MYD
8.0K mythconverg/music_smartplaylist_categories.MYI
4.0K mythconverg/music_smartplaylist_items.frm
4.0K mythconverg/music_smartplaylist_items.MYD
4.0K mythconverg/music_smartplaylist_items.MYI
4.0K mythconverg/music_smartplaylists.frm
4.0K mythconverg/music_smartplaylists.MYD
8.0K mythconverg/music_smartplaylists.MYI
12K mythconverg/music_songs.frm
24K mythconverg/music_songs.MYD
36K mythconverg/music_songs.MYI
4.0K mythconverg/music_stats.frm
0 mythconverg/music_stats.MYD
4.0K mythconverg/music_stats.MYI
12K mythconverg/music_streams.frm
18M mythconverg/music_streams.ibd
4.0K mythconverg/mythexport.frm
4.0K mythconverg/mythexport_job_queue.frm
96K mythconverg/mythexport_job_queue.ibd
0 mythconverg/mythexport.MYD
4.0K mythconverg/mythexport.MYI
52K mythconverg/mythlog.frm
56K mythconverg/mythlog.MYD
12K mythconverg/mythlog.MYI
8.0K mythconverg/mythsgu_archived.frm
2.1M mythconverg/mythsgu_archived.ibd
4.0K mythconverg/mythsgu_move.frm
580K mythconverg/mythsgu_move.ibd
4.0K mythconverg/mythweb_sessions.frm
104K mythconverg/mythweb_sessions.MYD
12K mythconverg/mythweb_sessions.MYI
4.0K mythconverg/networkiconmap.frm
0 mythconverg/networkiconmap.MYD
4.0K mythconverg/networkiconmap.MYI
4.0K mythconverg/oldfind.frm
4.0K mythconverg/oldfind.MYD
4.0K mythconverg/oldfind.MYI
4.0K mythconverg/oldprogram.frm
920K mythconverg/oldprogram.MYD
756K mythconverg/oldprogram.MYI
56K mythconverg/oldrecorded_export.frm
72K mythconverg/oldrecorded_export.MYD
104K mythconverg/oldrecorded_export.MYI
56K mythconverg/oldrecorded.frm
15M mythconverg/oldrecorded.MYD
14M mythconverg/oldrecorded.MYI
4.0K mythconverg/people.frm
288K mythconverg/people.MYD
384K mythconverg/people.MYI
4.0K mythconverg/phonecallhistory.frm
0 mythconverg/phonecallhistory.MYD
4.0K mythconverg/phonecallhistory.MYI
4.0K mythconverg/phonedirectory.frm
4.0K mythconverg/phonedirectory.MYD
4.0K mythconverg/phonedirectory.MYI
4.0K mythconverg/pidcache.frm
0 mythconverg/pidcache.MYD
4.0K mythconverg/pidcache.MYI
4.0K mythconverg/playgroup.frm
4.0K mythconverg/playgroup.MYD
4.0K mythconverg/playgroup.MYI
52K mythconverg/powerpriority.frm
4.0K mythconverg/powerpriority.MYD
4.0K mythconverg/powerpriority.MYI
48K mythconverg/powerpriority_tmp.frm
96K mythconverg/powerpriority_tmp.ibd
4.0K mythconverg/profilegroups.frm
4.0K mythconverg/profilegroups.MYD
12K mythconverg/profilegroups.MYI
60K mythconverg/program.frm
4.0K mythconverg/programgenres.frm
3.7M mythconverg/programgenres.MYD
2.4M mythconverg/programgenres.MYI
24M mythconverg/program.MYD
19M mythconverg/program.MYI
4.0K mythconverg/programrating.frm
272K mythconverg/programrating.MYD
328K mythconverg/programrating.MYI
4.0K mythconverg/real_names.frm
96K mythconverg/real_names.ibd
4.0K mythconverg/recgrouppassword.frm
0 mythconverg/recgrouppassword.MYD
4.0K mythconverg/recgrouppassword.MYI
4.0K mythconverg/recgroups.frm
4.0K mythconverg/recgroups.MYD
4.0K mythconverg/recgroups.MYI
4.0K mythconverg/recordedartwork.frm
0 mythconverg/recordedartwork.MYD
4.0K mythconverg/recordedartwork.MYI
4.0K mythconverg/recordedcredits.frm
16K mythconverg/recordedcredits.MYD
28K mythconverg/recordedcredits.MYI
8.0K mythconverg/recordedfile.frm
1.3M mythconverg/recordedfile.MYD
500K mythconverg/recordedfile.MYI
60K mythconverg/recorded.frm
4.0K mythconverg/recordedmarkup.frm
8.6M mythconverg/recordedmarkup.MYD
9.4M mythconverg/recordedmarkup.MYI
11M mythconverg/recorded.MYD
3.1M mythconverg/recorded.MYI
56K mythconverg/recordedprogram.frm
6.6M mythconverg/recordedprogram.MYD
2.4M mythconverg/recordedprogram.MYI
4.0K mythconverg/recordedrating.frm
788K mythconverg/recordedrating.MYD
1.2M mythconverg/recordedrating.MYI
4.0K mythconverg/recordedseek.frm
7.0G mythconverg/recordedseek.MYD
6.4G mythconverg/recordedseek.MYI
4.0K mythconverg/recordfilter.frm
4.0K mythconverg/recordfilter.MYD
4.0K mythconverg/recordfilter.MYI
56K mythconverg/record.frm
4.0K mythconverg/recordingprofiles.frm
4.0K mythconverg/recordingprofiles.MYD
4.0K mythconverg/recordingprofiles.MYI
4.0K mythconverg/recordmatch.frm
56K mythconverg/recordmatch.MYD
148K mythconverg/recordmatch.MYI
820K mythconverg/record.MYD
356K mythconverg/record.MYI
52K mythconverg/record_tmp.frm
2.0M mythconverg/record_tmp.ibd
8.0K mythconverg/romdb.frm
0 mythconverg/romdb.MYD
4.0K mythconverg/romdb.MYI
4.0K mythconverg/scan_channels.frm
112K mythconverg/scan_channels.ibd
4.0K mythconverg/scannerfile.frm
0 mythconverg/scannerfile.MYD
4.0K mythconverg/scannerfile.MYI
4.0K mythconverg/scannerpath.frm
0 mythconverg/scannerpath.MYD
4.0K mythconverg/scannerpath.MYI
4.0K mythconverg/schemalock.frm
0 mythconverg/schemalock.MYD
4.0K mythconverg/schemalock.MYI
52K mythconverg/settings.frm
36K mythconverg/settings.MYD
32K mythconverg/settings.MYI
52K mythconverg/settings_old.frm
24K mythconverg/settings_old.MYD
28K mythconverg/settings_old.MYI
4.0K mythconverg/storagegroup.frm
4.0K mythconverg/storagegroup.MYD
12K mythconverg/storagegroup.MYI
4.0K mythconverg/tvchain.frm
0 mythconverg/tvchain.MYD
4.0K mythconverg/tvchain.MYI
4.0K mythconverg/tvosdmenu.frm
4.0K mythconverg/tvosdmenu.MYD
4.0K mythconverg/tvosdmenu.MYI
12K mythconverg/upnpmedia.frm
2.3M mythconverg/upnpmedia.MYD
1.3M mythconverg/upnpmedia.MYI
4.0K mythconverg/user_permissions.frm
0 mythconverg/user_permissions.MYD
4.0K mythconverg/user_permissions.MYI
4.0K mythconverg/user_sessions.frm
4.0K mythconverg/user_sessions.MYD
8.0K mythconverg/user_sessions.MYI
4.0K mythconverg/users.frm
4.0K mythconverg/users.MYD
8.0K mythconverg/users.MYI
4.0K mythconverg/videocast.frm
12K mythconverg/videocast.MYD
8.0K mythconverg/videocast.MYI
4.0K mythconverg/videocategory.frm
0 mythconverg/videocategory.MYD
4.0K mythconverg/videocategory.MYI
8.0K mythconverg/videocollection.frm
0 mythconverg/videocollection.MYD
4.0K mythconverg/videocollection.MYI
4.0K mythconverg/videocountry.frm
4.0K mythconverg/videocountry.MYD
4.0K mythconverg/videocountry.MYI
4.0K mythconverg/videogenre.frm
4.0K mythconverg/videogenre.MYD
4.0K mythconverg/videogenre.MYI
4.0K mythconverg/videometadatacast.frm
8.0K mythconverg/videometadatacast.MYD
12K mythconverg/videometadatacast.MYI
4.0K mythconverg/videometadatacountry.frm
4.0K mythconverg/videometadatacountry.MYD
4.0K mythconverg/videometadatacountry.MYI
8.0K mythconverg/videometadata.frm
4.0K mythconverg/videometadatagenre.frm
4.0K mythconverg/videometadatagenre.MYD
12K mythconverg/videometadatagenre.MYI
9.2M mythconverg/videometadata.MYD
2.0M mythconverg/videometadata.MYI
4.0K mythconverg/videopart.frm
0 mythconverg/videopart.MYD
4.0K mythconverg/videopart.MYI
4.0K mythconverg/videopathinfo.frm
0 mythconverg/videopathinfo.MYD
4.0K mythconverg/videopathinfo.MYI
16K mythconverg/videosource.frm
4.0K mythconverg/videosource.MYD
8.0K mythconverg/videosource.MYI
4.0K mythconverg/videotypes.frm
4.0K mythconverg/videotypes.MYD
4.0K mythconverg/videotypes.MYI
4.0K mythconverg/weatherdatalayout.frm
128K mythconverg/weatherdatalayout.ibd
4.0K mythconverg/weatherscreens.frm
96K mythconverg/weatherscreens.ibd
4.0K mythconverg/weathersourcesettings.frm
96K mythconverg/weathersourcesettings.ibd
4.0K mythconverg/websites.frm
96K mythconverg/websites.ibd
root@mypvr:/var/lib/mysql# ll
/mnt/savaidh/ldrive/Backups/MythTV_db_backup/mypvr/
total 10670204
drwxrwxrwx 2 root root 0 Jan 8 10:02 ./
drwxrwxrwx 2 root root 12288 Aug 2 16:42 ../
-rwxrwxrwx 1 root root 2182641092 Jan 4 09:45
mythconverg-1348-20190104094148.sql.gz*
-rwxrwxrwx 1 root root 2183823426 Jan 5 09:45
mythconverg-1348-20190105094209.sql.gz*
-rwxrwxrwx 1 root root 2184524470 Jan 6 09:45
mythconverg-1348-20190106094217.sql.gz*
-rwxrwxrwx 1 root root 2186685665 Jan 7 09:43
mythconverg-1348-20190107094011.sql.gz*
-rwxrwxrwx 1 root root 2188589221 Jan 8 09:45
mythconverg-1348-20190108094156.sql.gz*
drwxrwxrwx 2 root root 0 Jul 17 05:40 old/
MariaDB [mythconverg]> select count(*) from recorded;
+----------+
| count(*) |
+----------+
| 31486 |
+----------+
1 row in set (0.00 sec)
MariaDB [mythconverg]> select count(*) from recordedseek;
+-----------+
| count(*) |
+-----------+
| 296906976 |
+-----------+
1 row in set (0.00 sec)
_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev http://wiki.mythtv.org/Mailing_List_etiquette MythTV Forums:
https://forum.mythtv.org