Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[meepmeep]

Hi

I use the latest version of Denora and MagIRC with an old db.
Last week I detected a lot of mysql error on my website, I think I find the origin today when I listed all the running process on mysql : http://pastebin.com/bgyVC6fN
To be sure, the extract above (90 process!) was made just 1h and 15min after I launched Denora, and it keeps getting bigger and bigger.

The funny think is that this problem doesn't occur when denora is running alone -without magIRC-, in these case, I have only 1 sleep process from Stats.
Is it a know bug/mysterious feature ? How could I correct it (I have temporarily closed magIRC) ?

[meepmeep]

Auto-reply / workaround :
In the file "lib/magirc/DB.class.php", I comment the following line (46) :

Code: [Select]

$args[PDO::ATTR_PERSISTENT] = true;
And now it runs smoothly ..

[Hal9000]

Interesting... afaik persistent connections are supposed to be better for high load scenarios in that the server does not need to open and close connections all the time...
Will investigate this and maybe deactivate that feature.