• 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!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

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