Thanks to Jeremy Zawodny for his great tool, I was
able to capture this during a server meltdown at the
hands of an upraded MySQL binary (From 3.23.32 to
3.23.52).
My story is a famliar one -- a db (MyISAM tables) that
ran fine for 3 years all of sudden brings our cpu to a
halt with an upgraded binary from MySQL.
RH, Linux 2.2.16-22enterprise, harmless load averages
until a few respectable queries are issued and we get
crippled.
Never seen a processlist like this though. It happens
within 30 seconds of the server getting throttled.
Thanks,
| 17546 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17547 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17548 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17549 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17550 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17551 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17552 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17553 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17554 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17555 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17556 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17557 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17558 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17559 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17560 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17561 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17562 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17563 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17564 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17565 | root| localhost | NULL | Connect | NULL |
login | NULL
|
| 17566 | root| localhost | NULL | Connect | NULL |
login | NULL
|
+-------+----------------------+-----------+---------+---------+------+-------
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
