[mythtv] backend from SVN 9761 bangs on mysqld

[Stuart Auchterlonie]

On Mon, Apr 24, 2006 at 07:24:48PM +0200, Janne Grunau wrote:
> 
> Sharing the cache would be insane, I see 2 million calls to the cache 
> per hour. But a static assignment of channels to backends is a 
> interesting idea.
> 

Though I have to say that was my original idea to share the cache
at a global level

> > > That gives something less than 1MB for my cache.
> >
> > Which sounds very reasonable. Lets see if it ever grows to
> > unreasonable size in a week or two of continuous use before
> > we start trying to 'solve' the memory usage problem, which
> > may not even exist anymore.
> 
> The cache will 'leak' memory since there is currently no method to prune 
> done events. But it is almost done, I have to think how often we should 
> call this method. The offset needs probably also some tests. 
> 

It will top out with

count(tsid) * count(eventid) * count(serviceid)

keys and grow no further after that.


Stuart