AW: HELP... lot of Load !

2001-12-11 Thread Daniel Backhausen
manually to view the load gage. Greetz Daniel -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Benjamin Pflugmann Gesendet: Dienstag, 11. Dezember 2001 22:04 An: Daniel Backhausen Cc: mySQL Mailingliste Betreff: Re: HELP... lot of Load ! Hi

Re: HELP... lot of Load !

2001-12-11 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 02:06:41PM +0100, [EMAIL PROTECTED] wrote: > --- [...] > # Time: 011210 13:40:23 > # User@Host: eff21[eff21] @ localhost [] > # Query_time: 25 Lock_time: 0 Rows_sent: 20 Rows_examined: 596309 > > S

AW: HELP... lot of Load !

2001-12-10 Thread Daniel Backhausen
ROUP BY Locations.Location_ID HAVING Loc_Kat != 1 OR (Count_Events != 0 AND Loc_Kat = 1) ; (END) --- Did this say anything to you advertently my high load ? Thank you for your time & regards - Daniel Backhausen -

Re: HELP... lot of Load

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 11:41:34AM +0100, [EMAIL PROTECTED] wrote: > Hi Benjamin. > > Thank you for your fast reply. I have another two small detailed questions. > 1st: Do you think, if I compile the mysql source on my own it should be > better ? > I readed, that RedHat 7 has pre-compiled th

AW: HELP... lot of Load

2001-12-10 Thread Daniel Backhausen
Pflugmann Gesendet: Montag, 10. Dezember 2001 11:28 An: Daniel Backhausen Cc: [EMAIL PROTECTED] Betreff: Re: HELP... lot of Load Hi. On Mon, Dec 10, 2001 at 11:06:24AM +0100, [EMAIL PROTECTED] wrote: > Hello. > > When I start the mysql database my load is nearly zero. After some time

Re: HELP... lot of Load

2001-12-10 Thread Benjamin Pflugmann
Hi. On Mon, Dec 10, 2001 at 11:06:24AM +0100, [EMAIL PROTECTED] wrote: > Hello. > > When I start the mysql database my load is nearly zero. After some time > e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s > are going wild till 90% user 10% system. Normaly this system co

HELP .. lot of load

2001-12-10 Thread Daniel Backhausen
Hello. When I start the mysql database my load is nearly zero. After some time e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s are going wild till 90% user 10% system. Normaly this system could handle a lot of database operations. Here are some system information: - Dual

HELP... lot of Load

2001-12-10 Thread Daniel Backhausen
Hello. When I start the mysql database my load is nearly zero. After some time e.g. 30 min the load goes up to 11-12 and sometimes up to 25. Both CPU´s are going wild till 90% user 10% system. Normaly this system could handle a lot of database operations. Here are some system information: - Dual