Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Ken Menzel
L PROTECTED] - Original Message - From: "Noor Dawod" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]>; "Sinisa Milivojevic" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22,

RE: Unexplained high-loads on FreeBSD

2001-01-22 Thread Noor Dawod
Sent: Monday, January 22, 2001 6:09 PM To: Sinisa Milivojevic; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Unexplained high-loads on FreeBSD Hi Sinisa and everyone, I have a question for Noor, after updating freeBSD-stable last week, I assume you did a "make wo

Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Ken Menzel
To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 9:25 AM Subject: RE: Unexplained high-loads on FreeBSD > Noor Dawod writes: > > Hi Sinisa > > > > Is the FreeBSD problem previously submitted by me known to

Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Sinisa Milivojevic
Herald van der Breggen writes: > Sinisa Milivojevic wrote: > > > Do you know whether the problem is related to glibc 2.1, or to the 2.2 > kernel or to both ? > > With other words : do I really need the 2.4 kernel, which will be al lot > of work, since a lot has changed (firewalling fo

Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Herald van der Breggen
Sinisa Milivojevic wrote: > > > Hi! > > The above is an already reported problem that occurs only on SMP Linux > on the high load. > > A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build > properly MySQL on that setup. > > > Regards, > > Sinisa Do you know whether the pr

RE: Unexplained high-loads on FreeBSD

2001-01-22 Thread Sinisa Milivojevic
Noor Dawod writes: > Hi Sinisa > > Is the FreeBSD problem previously submitted by me known to you? > > Noor Ken Manzel has submitted many valuable messages to this mailing list concerning many important patches for FreeBSD 4.* threads. He has even provided names of files and dates when

Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Sinisa Milivojevic
Herald van der Breggen writes: > Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l > investigate the other possibilities anyway). > > No, downgrading would not be beneficial to you ! Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*

RE: Unexplained high-loads on FreeBSD

2001-01-22 Thread Noor Dawod
-loads on FreeBSD Herald van der Breggen writes: > Hello Noor, > > I am struggling with a similar problem on a linux based system. It's a > Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L > scsi controler. > > On certain moments, mostly in the

Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Herald van der Breggen
Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l investigate the other possibilities anyway). Sinisa Milivojevic wrote: > Herald van der Breggen writes: > > Hello Noor, > > > > I am struggling with a similar problem on a linux based system. It's a > > Netfinity 450

Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Sinisa Milivojevic
Herald van der Breggen writes: > Hello Noor, > > I am struggling with a similar problem on a linux based system. It's a > Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L > scsi controler. > > On certain moments, mostly in the peak hours, mysql suddenly behaves > w

RE: Unexplained high-loads on FreeBSD

2001-01-22 Thread Noor Dawod
queries that cause this problem, then to what direction should I care most? Thanks Noor -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 9:55 PM To: Noor Dawod Cc: MySQL List Subject: Re: Unexplained high-loads on FreeBSD You didn&#

Re: Unexplained high-loads on FreeBSD

2001-01-21 Thread Herald van der Breggen
I hope so. A point that my Noor's situation and mine have in common is fast disks. Maybe there is a timeng problem ? Another remarkeble table I did not mention is a table with a blob-field. The blob field is used to store perl-objects with a size of about 8Kb. The table is about 3000 rows lar

Re: Unexplained high-loads on FreeBSD

2001-01-21 Thread Vibol Hou
lems... > > What do you suggest? > > Noor > > > -Original Message- > From: Jan Tegtmeier [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 21, 2001 4:53 PM > To: [EMAIL PROTECTED] > Subject: Unexplained high-loads on FreeBSD > > > Hi Noor,

Re: Unexplained high-loads on FreeBSD

2001-01-21 Thread Herald van der Breggen
Good question. I can give you some details about the database I am using. This is about another situation than Noor's (linux instead of FreeBSD), but the problems looks similar. I have not find any specific event that causes mysqld spinning around and claiming memory. I activited the logging

Re: Unexplained high-loads on FreeBSD

2001-01-21 Thread scott
You didn't give any details about the database and how it is being used/accessed. There may NOT be anything wrong with your setup. It may actually be inefficiencies in your code or queries that are causing the problems. Also Note MySQL 3.23.31 has a serious bug! - Scott > Hello all

Re: Unexplained high-loads on FreeBSD

2001-01-21 Thread Herald van der Breggen
Hello Noor, I am struggling with a similar problem on a linux based system. It's a Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L scsi controler. On certain moments, mostly in the peak hours, mysql suddenly behaves weird and the load increases very very quick. The swap u

RE: Unexplained high-loads on FreeBSD

2001-01-21 Thread Noor Dawod
[EMAIL PROTECTED] Subject: Unexplained high-loads on FreeBSD Hi Noor, have you tried to run a "show processlist" within mysql during these OVERHEAT situations to find out if there is a query forcing this high load? You could also activate the logfile for slow queries (starting mysqld with --log-slo

Unexplained high-loads on FreeBSD

2001-01-21 Thread Jan Tegtmeier
Hi Noor, have you tried to run a "show processlist" within mysql during these OVERHEAT situations to find out if there is a query forcing this high load? You could also activate the logfile for slow queries (starting mysqld with --log-slow-queries[=file_name])... maybe you will get some info from

Unexplained high-loads on FreeBSD

2001-01-21 Thread Noor Dawod
Hello all, I've been trying to fix a problem we're facing without luck for the last few weeks. I also searched mailing lists for a similar problem, both MySQL and FreeBSD, without luck. The situation is as follows... A brank new server was deployed last month for our company. It's a 933Mhz Xeon-