[mythtv-users] Is 4GB RAM overkill for mythtv?

[Matthew McClement]

Yeechang Lee wrote:
> Matthew McClement <mythtv at macker.co.uk> says:
>> sort_buffer, read_buffer, join_buffer and read_rnd_buffer should all
>> be ~2M in size(I can't think of any common MythTV related queries
>> that would generate a result set over 2M).
> 
> Might this change if my patch
> (<URL:http://svn.mythtv.org/trac/ticket/4626>) to raise the current
> 1,000-line limit on query results to 20,000 gets accepted?

Depends on the row size of the select. No way to figure this out without 
doing some query logging and watching the queries. Assuming the select 
involves most of the program table, you can guestimate things by doing a 
"show table status where Name = 'program'\G" and looking at Avg_row_length.

Matt