2008/1/23, Martijn van den Burg <[EMAIL PROTECTED]>: > Hi, > > My DEV server is used by many people creating apps throughout the > company. Consequently, I have no insight in the efficiency or quality of > their SQL. This is an accepted state of affairs. > > However, 'developers' have repeatedly managed to crash mysqld because > their queries are huge, don't use indexes, etc. At those times, the load > on the box (dual-CPU, 4GB RAM) is 23, and I can't even ssh into it > anymore.
I would advise you to tune down some MySQL server variable sto use less resources, so that at least the machine itself keeps working (for SSH etc.) even if MySQL grinds to a halt. JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
