[mythtv] Why are there so many instances of recordedseek?
dennis
deg at outlook.com
Wed Apr 22 02:36:31 UTC 2015
>
> 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.
More information about the mythtv-dev
mailing list