[mythtv] Video playback framerate

Stephen Worthington stephen_agent at jsw.gen.nz
Tue Jan 8 02:58:09 UTC 2019


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 at mypvr:/var/lib/mysql# du -h mythconverg
14G     mythconverg

root at 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 at 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)


More information about the mythtv-dev mailing list