• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

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