Hi all, once again, I would like to point to my problem of using a persistent mysql-connection discribed below. Nobody any ideas? -------- Original-Nachricht -------- Datum: Thu, 27 Apr 2006 15:35:19 +0200 Hi, I want to use a persistent mysql-connection to speed up OTRS. I followed README.webserver and set up mod_perl on apache v1.3 which I didn't use before. Additionally, I included Perlrequire /opt/otrs/scripts/apache-perl-startup.pl Finally, I activated #use Apache (); #use Apache::DBI (); #Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs', 'some-pass'); with the same user/password like in ~/Kernel/Config.pm Know, the apache startup really takes a long time and OTRS needs only half the time to load a page than on cgi-mode. But the problem is that show processlist e.g. always shows the same proccess-id for my phpMyAdmin-connection, but always flushing and disappearing diffent process-ids for my otrs-connection. So I think OTRS currently doesn't use persistent DB-connections. What's wrong - any advice? Thanks, Alex
Hallo. In the German list is alos a discussion about this. Subject: "pers. DB Verbindungen unter mod_perl2" It seems this is a bug. http://bugs.otrs.org/show_bug.cgi?id=1050 -- Best regards André Bauer System: Debian 3.1 / Apache 2.0.54 / MySQL 4.0.24 / OTRS 2.0.4 ============================================ AS> Hi all, AS> once again, I would like to point to my problem of using a persistent AS> mysql-connection discribed below. Nobody any ideas? AS> -------- Original-Nachricht -------- AS> Datum: Thu, 27 Apr 2006 15:35:19 +0200 AS> Hi, AS> I want to use a persistent mysql-connection to speed up OTRS. AS> I followed README.webserver and set up mod_perl on apache v1.3 which I AS> didn't use before. AS> Additionally, I included AS> Perlrequire /opt/otrs/scripts/apache-perl-startup.pl AS> Finally, I activated AS> #use Apache (); AS> #use Apache::DBI (); #Apache::DBI->>connect_on_init('DBI:mysql:otrs', 'otrs', 'some-pass'); AS> with the same user/password like in ~/Kernel/Config.pm AS> Know, the apache startup really takes a long time and OTRS needs only AS> half the time to load a page than on cgi-mode. AS> But the problem is that AS> show processlist AS> e.g. always shows the same proccess-id for my phpMyAdmin-connection, AS> but always flushing and disappearing diffent process-ids for my AS> otrs-connection. AS> So I think OTRS currently doesn't use persistent DB-connections. AS> What's wrong - any advice? AS> Thanks, Alex AS> _______________________________________________ AS> OTRS mailing list: otrs - Webpage: http://otrs.org/ AS> Archive: http://lists.otrs.org/pipermail/otrs AS> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs AS> Support oder Consulting f OTRS System? =>> http://www.otrs.de/
participants (2)
-
Alexander Scholler -
André Bauer