[rt-users] Runaway MySQL and RT

[steve at pipenetworks.com]

Hello,

I have just installed  RT (rt-2-0-9) on a RedHat 7.1 box and am seeing
some strange behaviour. It seems that the MySQL processes are
accumulating !  After just a few clicks I have 42 mysqld processes
running, this will keep going until it reaches 105 and then the system
dies.

I think there may be an issue with the way that Apache/DBD/DBI talks to
the MySQL server. I installed as per the instructions but chose to install
all of the required perl modules by hand instead of letting 'fixdeps' do
it for me as that has failed on a number of occasions. I could not get the
same version numbers that the RT testdeps was looking for but it still
seemed happy with the ones I installed.

RT seems to work OK except that you need to issue a restart to the
database every now and again.

The MYSQL version is :

mysqladmin  Ver 8.18 Distrib 3.23.36, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          3.23.36
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 7 min 32 sec

Threads: 37  Questions: 399  Slow queries: 0  Opens: 46  Flush tables: 1 Open tables: 17 Queries per second avg: 0.883

If it helps I have the following othe rmodules and programs installed :

apache_1.3.23
ApacheDBI-0.71
Apache-Filter-1.019
Apache-Session-1.54
Attribute-Handlers-0.76
AxKit-1.5
CGI.pm-2.80
Data-Dumper-2.101
Data-ShowTable-3.3
DBD-mysql-2.1011
DBI-1.21
DBIx-DataSource-0.02
DBIx-SearchBuilder-0.48
Digest-MD5-2.16
File-Spec-0.82
File-Temp-0.12
FreezeThaw-0.41
Getopt-Long-2.29
HTML-Mason-0.896
HTML-Parser-3.25
HTML-Tagset-3.03
IO-stringy-2.108
libnet-1.10
libwww-perl-5.64
Log-Dispatch-1.80
MailTools-1.43
MIME-Base64-2.12
MIME-tools-5.411
MLDBM-2.00
mod_perl-1.26
Msql-Mysql-modules-1.2219
Params-Validate-0.07
Storable-1.0.14
Text-Template-1.42
Text-Wrapper-1.000
Tie-IxHash-1.21
TimeDate-1.11
URI-1.18
XML-Grove-0.05
XML-Parser-2.30





Any help greatly appreciated :-)



-- 
Stephen Baxter
Pipe Networks 
phone : +61 417 818 695
fax   : +61 7 3207 3713