Re: Load Average more than 400

2004-01-26 Thread Daniela
On Tuesday 28 October 2003 17:05, Varshavchick Alexander wrote: > Hi gurus, > > can you please hint as what parameters I have monitor to find the cause of > sudden splashes of load of a FreeBSD 4.6.2-RELEASE server? This box is > acting as a database/mysql server and periodically goes up to 400 of

Re: Load Average more than 400

2003-10-29 Thread Steve Hovey
how bout systat - that might flush up which is goin nuts On Wed, 29 Oct 2003, Varshavchick Alexander wrote: > On Tue, 28 Oct 2003, Daniela wrote: > > > Watch your top (or ps -ax) output. Anything odd there? > > > > Nothing odd - many mysqld processes as usual... > > > Alexander Varshavc

Re: Load Average more than 400

2003-10-29 Thread Varshavchick Alexander
On Tue, 28 Oct 2003 [EMAIL PROTECTED] wrote: > MySQL has done this to me after an unclean shutdown. > Try stopping mysqld and running myisamchk -r on all tables. first of all, I use mostly innodb tables, and secondly, and besides, there was indeed an unclean shutdown recently but already several

Re: Load Average more than 400

2003-10-29 Thread Varshavchick Alexander
On Tue, 28 Oct 2003, Daniela wrote: > Watch your top (or ps -ax) output. Anything odd there? > Nothing odd - many mysqld processes as usual... Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) ___ [EMAIL PROT

Re: Load Average more than 400

2003-10-29 Thread Varshavchick Alexander
On Tue, 28 Oct 2003, Charles Swiger wrote: > What does "ps auxw" look like when you have this load spike? Nothing unusual - mysqld processes, nothing else... Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) __

Re: Load Average more than 400

2003-10-28 Thread f-freebsd
On Tue, Oct 28, 2003 at 08:05:15PM +0300, Varshavchick Alexander wrote: > Hi gurus, > > can you please hint as what parameters I have monitor to find the cause of > sudden splashes of load of a FreeBSD 4.6.2-RELEASE server? This box is > acting as a database/mysql server and periodically goes up t

Re: Load Average more than 400

2003-10-28 Thread Charles Swiger
On Tuesday, October 28, 2003, at 12:05 PM, Varshavchick Alexander wrote: can you please hint as what parameters I have monitor to find the cause of sudden splashes of load of a FreeBSD 4.6.2-RELEASE server? This box is acting as a database/mysql server and periodically goes up to 400 of load aver

Load Average more than 400

2003-10-28 Thread Varshavchick Alexander
Hi gurus, can you please hint as what parameters I have monitor to find the cause of sudden splashes of load of a FreeBSD 4.6.2-RELEASE server? This box is acting as a database/mysql server and periodically goes up to 400 of load average values and then gradually returns to a normal 4-5 value. The