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