[mythtv-users] Sloooow database

[Brad DerManouelian]

On Jun 11, 2008, at 11:09 AM, Curtis Stanford wrote:

> Actually it's over 100,000 rows. Still, mysql should handle it OK.  
> My file system has plenty of space. After looking some more at it, I  
> think it may be swapping a little bit. What my.cnf settings do you  
> use? I think mine are a little high for 512M. I'm using Brad's  
> setting right now:
>
> 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

I looked for this thread before and didn't find it until just now, but  
it has a GREAT explanation of how to tune your database settings based  
on what you have to work with:
http://www.gossamer-threads.com/lists/mythtv/users/318341
Especially:
http://www.gossamer-threads.com/lists/mythtv/users/318648#318648

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080611/d088fe31/attachment.htm