[mythtv-users] Sloooow database
curtis at stanfordcomputing.com
Sat Jun 7 22:48:30 UTC 2008
On 6-Jun-08, at 10:26 AM, Brad DerManouelian wrote:
> On Jun 6, 2008, at 9:10 AM, Curtis Stanford wrote:
>> Hey everyone, here's something I've put up with for a long time and
>> thought I'd try to resolve it.
> Is your backend swapping? Have you optimized mysql in your my.cnf file
> at all?
> I have 2GB in my backend, so I set /etc/my.cnf with this:
> key_buffer = 32M
> table_cache = 256
> sort_buffer_size = 4M
> myisam_sort_buffer_size = 16M
> query_cache_size = 64M
> query_cache_limit = 8M
> query_cache_type = 1
> It's much faster than the default settings. I could probably give it
> more memory, but I do lots of transcoding and other stuff on my
> backend so I didn't want to push it too much.
Thanks Brad, yes I did optimize my.cnf:
key_buffer = 48M
table_cache = 128
sort_buffer_size = 48M
myisam_sort_buffer_size = 8M
query_cache_size = 64M
query_cache_limit = not set
query_cache_type = 1
I'll try your settings and see what happens. I only have 512M but I
don't think it's swapping much.
More information about the mythtv-users