[mythtv-users] Sloooow database
Brad DerManouelian
myth at dermanouelian.com
Wed Jun 11 18:19:07 UTC 2008
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
More information about the mythtv-users
mailing list