Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: Too many process on mysql for Denora and magIRC  (Read 6657 times)

0 Members and 1 Guest are viewing this topic.

meepmeep

  • Anope User
  • Offline Offline
  • Posts: 12
Too many process on mysql for Denora and magIRC
« on: April 15, 2013, 11:49:27 PM »

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) ?
Logged

meepmeep

  • Anope User
  • Offline Offline
  • Posts: 12
Re: Too many process on mysql for Denora and magIRC
« Reply #1 on: April 21, 2013, 01:47:10 PM »

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 ..
Logged

Hal9000

  • Team
  • *
  • Offline Offline
  • Posts: 103
Re: Too many process on mysql for Denora and magIRC
« Reply #2 on: April 22, 2013, 07:14:21 PM »

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.
Logged
Pages: [1]   Go Up