[mythtv-users] Sloooow database

[Curtis Stanford]

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.

Curtis