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
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