Hi,
I've been running 3.23.37 on a redhat box. with zero problems for a
very long time. For the past 4 days or so I've had a persistent problem.
I think I had a user with an out of control query which caused the system to
run out of VM. I tried shutting down with mysqladmin but it failed. I had
to reboot (issued a linux shutdown, I did not have to power cycle) and ever
since then the system has never been the same.
In general, I have very slow performance but system top reports cpu usage of
about 0.2 and I am not swapping. I am logging slow queries and have
discovered that some simple ones like "select * from someTable" are listed
as slow and take 15 seconds or more.
I'm not currently concerned with performance, I'm worried about platform
stability because when I issue
mysqladmin -p******** shutdown
it does not return. and I have several hundred processes of
"/usr/local/mysql" listed by ps aux | grep mysql. Killall doesn't kill them
and if I kill them individually they respawn ( I don't honestly understand
how they are controlled)
and the final symptom/clue is that when I restart mysql, show processlist
returns hundreds of:
| 3 | unauthenticated user | 195.46.64.45 | | Connect | | login |
|
| 4 | unauthenticated user | 209.142.4.9 | | Connect | | login |
|
| 5 | unauthenticated user | 62.39.122.16 | | Connect | | login |
|
| 6 | unauthenticated user | 195.46.64.45 | | Connect | | login |
|
| 7 | unauthenticated user | 209.142.4.9 | | Connect | | login |
|
| 8 | unauthenticated user | 212.119.163.4 | | Connect | | login |
|
| 9 | unauthenticated user | 66.186.23.140 | | Connect | | login |
|
| 10 | unauthenticated user | 194.42.44.8 | | Connect | | login |
|
| 11 | unauthenticated user | 213.194.109.99 | | Connect | | login |
|
| 12 | unauthenticated user | 192.168.0.1 | | Connect | | login |
|
| 13 | unauthenticated user | 217.96.80.2 | | Connect | | login |
|
| 14 | unauthenticated user | 209.142.4.9 | | Connect | | login |
|
| 15 | unauthenticated user | 62.39.122.16 | | Connect | | login |
|
apparently these are all people waiting to get in! but they never seem to
clear out.
My questions are basically.....what can I do when mysqladmin can't shut the
server down? (I resorted to rebooting which I hate to do) How can I
identify the source of my bottleneck? It doesn't appear to be CPU nor
memory or even network (I use traffic shaping to limit bandwidth to/from the
box).
Thanks very much,
Gary H.
P.S. Yes, I'm upgrading next week :))
---------------------------------------------------------------------
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
