[mythtv] Why are there so many instances of recordedseek?

[dennis]

>
> I have 8GB on a frontend/backend combo and that has been sufficient.
>
> There are a couple of different "tuning" scripts available. Some of 
> the recommendations may or may not be the best. But having them for 
> statistics reporting is useful.  For example, they can tell you the 
> total size of the indexes in on disk. Surprisingly, mine total 175 
> MB.  Setting the key buffer size to 200MB gives 99% cache hit rate. 
> That's very little RAM for the return.
>
> With a decent amount of RAM, one can experiment with the mysql temp 
> directory (tmpdir parm) on a tmpfs mount too.
>

Before changing the key_buffer_size you might want to check your 
existing cache hit rate.   I have several hundred recordings and even 
with the key_buffer_size at the default 16MB,  I am getting well over 
99% cache hit rate.

Moving the temp directory to tmpfs in many cases will give a nice boost 
in performance, especially if the your tmp directory is on a mechanical 
disk.   I just use the /run/mysqld directory, since /run is typically 
mounted as a tmpfs already.