No, I mean: tuning the mysql server variables in the /etc/my.cnf configuration.
See e.g.: http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html JP 2008/1/23, Martijn van den Burg <[EMAIL PROTECTED]>: > JP, > > Interesting option. You mean like re-nice-ing mysqld on the host (Linux) > level? > > > Martijn > > > -----Original Message----- > > From: Jan Pieter Kunst [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, January 23, 2008 14:09 PM > > To: Martijn van den Burg > > Subject: Re: Killing resource hogs - automatically > > > > 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]
