> 1) We have no idea why this happens at that particular time. There are
> no crons that run then, and we think have a finite ammount of users
> accessing the system who do not do anything different at the time the
> spike happens. The site is public though, so perhaps spiders could be
> doing this
Hi. We are using Apache::DBI to connect mod_perl to
mysql.
Suddenly (at about 21:00 GMT every day) the number
of mysql processes spirals into chaos. From a stable 8 to 20 processes, it jumps
up to 70 processes. This uses up all our 510MB RAM, swap-space gets used, and
the system grinds to
John Cameron wrote:
2) Does Apache create a new mysql connection/process for EVERY child
apache process that is spawned?
It creates one in each process that uses the database.
I assume some apache processes are spawned to handle simple
non-database actions such as retrieving a graphic or st
ill the connection be made automatically?
- Original Message -
From: "Perrin Harkins" <[EMAIL PROTECTED]>
To: "John Cameron" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 18, 2002 4:05 PM
Subject: Re: Do all apache childs create persi
Hi John,
Maybe consider using MyTop
(http://jeremy.zawodny.com/mysql/mytop/) to view the state of queries when
your server comes under load. It will show what your database is doing to
choke your system.
Has a table become too big to insert into quickly? Move to an
archive. Cons
John Cameron wrote:
Thankyou! We are using connect_on_init, so this may explain our problem.
What happens if I turn off connect_on_init? Do I need to change our code in
any way? Or will the connection be made automatically?
The connection will be made when you first do a DBI connect in that
p