[mythtv] Too many connections to database

[Kenneth Aafløy]

On Friday 09 April 2004 01:03, Brian May wrote:
> >>>>> "Mark" == Mark Edwards <irish at irishmark.co.uk> writes:
>
>     Mark> I haven't had this issue since I added:
>     Mark> max_connections=300
>
>     Mark> to my /etc/mysql/my.cnf
>
>     Mark> I suspect it has something to do with mythweb, but I don't
>     Mark> have any evidence to back it up...
>
> I was using current CVS (at least it was current 2 days ago), and not
> using mythweb (which is currently broken because I haven't recompiled
> it...).
>
> According to the reference someone posted, mysql supports 100
> connections by default, on my system there should only be 1 connection
> used (or sometimes 2). I should have heaps to spare.

Nope, mythtv creates multiple connections to the database from the different 
threads (to avoid having to deal with thread syncronisation), whether some of 
those is not closed down properly is another issue. Have you checked `netstat 
-tuap` when this occurs?

-- 

Kenneth Aafløy
ke-aa at frisurf.no