[Openinteract-help] OI, SPOPS and many databases

[Andreas N. <an...@kl...>]

Hello all,

we are currently falling about a problem, where our MySQL servers are
swamped with DB connections.

The problem is, that for each OI project ( and we really have lots of
them.. ), we define a database object in server.ini, although many of
those really only go to different database instances on the same server,
like this:

dbname test = server1 database test
dbname addr = server1 database addr
etc.

If we would not kick connections with wait_timeout, then our server
would have 1000 connections within seconds.

Now from my memory ( which is sometimes imagination, though #:-o  ),
there was a SPOPS configuration parameter for this, which would add the
correct "use database" statement before each statement.  If this comes
from my imagination, how about implementing this - would that be hard ?

Another related issue: can you add a sort of "init statements"
somewhere, which the server runs when establishing connections ? This
would be handy for setting db session related parameters.

thanks and cheers

Andreas
-- 
Andreas Nolte <an...@kl...>