• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

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