High mysqld load

Bjorn Swift bjorn@swift.st
Mon, 11 Feb 2002 18:46:58 -0000


Dear listmembers.

I am running IMP RELENG_3 and Horde Framework RELENG_2 on a FreeBSD 4.5-RC
box. My webserver is Apache/1.3.22 (Unix) PHP/4.1.1 and the mysqld is
3.23.39 - installed from ports.

A few times now I have noticed that mysqld tends to hang at 100% cpu.
Mysql's 'show processlist' returns something like this.

+-----+----------+-----------+-------+---------+------+-------+-------------
-----+
| Id  | User     | Host      | db    | Command | Time | State | Info
|
+-----+----------+-----------+-------+---------+------+-------+-------------
-----+
| 420 | hordemgr | localhost | horde | Sleep   | 1348 |       | NULL
|
| 547 | hordemgr | localhost | horde | Sleep   | 1845 |       | NULL
|
| 548 | hordemgr | localhost | horde | Sleep   | 1328 |       | NULL
|
| 567 | hordemgr | localhost | horde | Sleep   | 2164 |       | NULL
|
| 612 | hordemgr | localhost | horde | Sleep   | 506  |       | NULL
|
| 616 | hordemgr | localhost | horde | Sleep   | 1342 |       | NULL
|
....
....

Mysql's error log includes lines like these:

020211 16:46:52  Aborted connection 322 to db: 'horde' user: 'hordemgr'
host: `localhost' (Got timeout reading communication packets)
020211 16:46:52  Aborted connection 458 to db: 'horde' user: 'hordemgr'
host: `localhost' (Got timeout reading communication packets)
020211 16:46:52  Aborted connection 316 to db: 'horde' user: 'hordemgr'
host: `localhost' (Got timeout reading communication packets)

The only way out of this "loop" is to stop/start the mysqld.

Has anyone seen behaviour like this? The mysqld is hardly doing anything
else than serving Horde (two small databases) so this is my guess so far. Am
I perhaps looking in the wrong place?

As of now I am compiling mysqld 3.23.48 with the debugging option to try to
track the problem.

Thanks for your time,
Björn Swift