• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Plesk 8.2 : php.ini and Mysql persistent connections

P

pygmalion

Guest
Hello,

I have a problem with my MySql server , and I am very not an expert :)
My MySql server was down twice a day.

I noticed with phpmyadmin that there was a lot of sleeping process coming from 1 php script using mysql through adodb.

I thought that Adodb was probably using persistent connections ( not expert enough to be sure of that )

The only way I found to go over this, was to set mysql.allow_persistent = off in the etc/php4/apache2/php.ini file. Since this modification, all is working fine, but I am anxious because I am not sure if this will not perturb
Plesk (8.2) .

Is this dangerous ? or is there an another place where I can more safely disable mysql persistent connections for 1 domain ?

I tried without success to add this command :
- inside a local php.ini file
- or here in var/www/vhosts/mydomain.com/conf/httpd.include
<IfModule mod_php4.c>
php_admin_flag engine off
php_admin_flag msql.allow_persistent off
</IfModule>

No one was working. Only the main php.ini was ok.

Thanks for your help.

Roger
 
Back
Top