[mythtv-users] Sloooow database

[Curtis Stanford]

On 11-Jun-08, at 12:19 PM, Brad DerManouelian wrote:

> 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
>

I think you were right, Brad. I implemented the suggestions in that  
post but I really got a speed up when I killed the apache server that  
was running mythweb. Just tuning some parameters and giving mysql more  
RAM helped out a lot.

Curtis

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