[mythtv-users] Database tuning

Raymond Wagner raymond at wagnerrp.com
Tue Sep 3 11:27:51 UTC 2013


On Sep 1, 2013, at 12:00, Keith Pyle <kpyle at austin.rr.com> wrote:
> 
> The SSD alone will likely help if your performance issue is due to disk I/O.  However, you should consider creating a tmpfs for /tmp if you feel there is sufficient memory in the system.  I use a 1 GB tmpfs, but 500 MB might be sufficient for your use. If /tmp is on a tmpfs, your I/O for temporary tables should be even faster than what you can achieve with a SSD.

Why not just edit your my.cnf and bump up its limits such that MySQL just keeps those temporary tables in memory all on its own, and never tries to flush them out to storage?


More information about the mythtv-users mailing list