Database Thread Connection Issues

[Jason MarstellerFree User Post count: 21]

Whenever we activate Geodirectory on our live server, it HAMMERS our database. Within just minutes, Geodirectory can create more than 100 sleeping thread connections to our database, and they never stop sleeping.

Considering our connection limit is 151 and this happens even when the site is not busy, we are not sure we can continue with using the plugin. Any help here?

[KorModerator Post count: 16516]

Hi Jason,

Thanks for reaching us. Just letting you know that I’ve already assigned another member of the team to assist you with your concern. 🙂

Thanks!

[Jason MarstellerFree User Post count: 21]

This reply has been marked as private.

[PaoloSite Admin Post count: 31206]

Yes it will, but if your database is hammered by the plugin with no traffic, it means that the server hosting the database is not good enough.

Thanks

[Jason MarstellerFree User Post count: 21]

This reply has been marked as private.

[PaoloSite Admin Post count: 31206]

Gd Booster is an HTML cache. Database threads will not be affected, however it is not normal at all that Geodirectory would leave a bunch of sleeping database threads connected to the server without shutting them down.

If you please provide a link and admin credentials in a private reply, I’ll ask to the developers to find what’s wrong on your install.

Thanks

[Jason MarstellerFree User Post count: 21]

This reply has been marked as private.

[PaoloSite Admin Post count: 31206]

Yes please, that should be enought to troubleshoot the problem.

If you can install query monitor plugin in advance for our developers, you’ll make their like easier.

Let us know,

Thanks

[Jason MarstellerFree User Post count: 21]

This reply has been marked as private.

[Stiofan O’ConnorSite Admin Post count: 22956]

Hello,

Until you get access can you try adding this line to your theme functions.php

add_filter('xmlrpc_enabled', '__return_false');

The more access i can get the better, DB, FTP etc.

Thanks,

Stiofan

[Jason MarstellerFree User Post count: 21]

This reply has been marked as private.

[Stiofan O’ConnorSite Admin Post count: 22956]

anywhere after the

<?php

Stiofan

[PaoloSite Admin Post count: 31206]

Right below the opening

<?php

tag will do.

Let us know.

Thanks

[Jason MarstellerFree User Post count: 21]

This reply has been marked as private.

[Stiofan O’ConnorSite Admin Post count: 22956]

Does the same thing happen if you just activate GD alone and no addons? I tried and it only added 2 queries to the homepage load. Is there a way i can access your proccess viewer and FTP and i can prob get to the root of the problem?

Stiofan

[Author]

Posts