Hello, I run a PHP/MySQL environment. This may be more of a PHP question, but I'll take my chance here.
I have 3 different servers: - 1 running apache2 + php4 - 1 running mysql 5.0 - 1 running mysql 4.1 On the web server, I run multiple php applications which all connect to the MySQL database servers. Some of the applications make some very long queries ( phpsyslog-ng[1] and BASE[2] ) Whenever I launch a query from one of the application and then in the other one, the second query seems to be queued at the web server, although the mysql php module is configured to have unlimited persistent links. Both application's databases were sitting on the same db server (4.1); now php-syslog-ng is on the 4.1 and base on the 5.0 and I experience the same issue. Both applications have their own username and password to the db. Does someone have any idea how I could resolve this issue ? TIA [1] php-syslog-ng http://sourceforge.net/projects/php-syslog-ng/ [2] BASE http://base.secureideas.net/ Jean-Sébastien Pilon Systems Administrator Penson Financial Services Canada Inc. % Tel.: 514.841.9724 #269 % Cell: 514.771.0365 NOTICE: This email contains privileged and confidential information and is intended only for the individual to whom it is addressed. If you are not the named addressee, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this transmission by mistake and delete this communication from your system. E-mail transmission cannot be guaranteed to be secured or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. AVIS: Le présent courriel contient des renseignements de nature privilégiée et confidentielle et nest destiné qu'à la personne à qui il est adressé. Si vous nêtes pas le destinataire prévu, vous êtes par les présentes avisés que toute diffusion, distribution ou reproduction de cette communication est strictement interdite. Si vous avez reçu ce courriel par erreur, veuillez en aviser immédiatement lexpéditeur et le supprimer de votre système. Notez que la transmission de courriel ne peut en aucun cas être considéré comme inviolable ou exempt derreur puisque les informations quil contient pourraient être interceptés, corrompues, perdues, détruites, arrivées en retard ou incomplètes ou contenir un virus. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
