Re: Load Average more than 400
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 load > average values and then gradually returns to a normal 4-5 value. The > server is a dual Xeon with 4G phisical memory, mysql 4.0.7/linuxthreads. > During the highest load, the amount of Inact memory remains of about 2G, > and swap is used only minimally, so this cannot be the case. There are no > messages in a system log or mysql log. > > Any help is greatly appreciated, thanks is advance Watch your top (or ps -ax) output. Anything odd there? Daniela ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Load Average more than 400
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 Varshavchick, Metrocom Joint Stock Company > Phone: (812)118-3322, 118-3115(fax) > ___ > [EMAIL PROTECTED] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Load Average more than 400
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 hours had passed so it couldn't be the cause of it as it seems. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Load Average more than 400
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 PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Load Average more than 400
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) ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Load Average more than 400
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 to 400 of load > average values and then gradually returns to a normal 4-5 value. The > server is a dual Xeon with 4G phisical memory, mysql 4.0.7/linuxthreads. > During the highest load, the amount of Inact memory remains of about 2G, > and swap is used only minimally, so this cannot be the case. There are no > messages in a system log or mysql log. > > Any help is greatly appreciated, thanks is advance MySQL has done this to me after an unclean shutdown. Try stopping mysqld and running myisamchk -r on all tables. m&f -- What do you care what other people think? pgp0.pgp Description: PGP signature
Re: Load Average more than 400
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 average values and then gradually returns to a normal 4-5 value. What does "ps auxw" look like when you have this load spike? -- -Chuck ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"