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 4500R, dual

RE: Unexplained high-loads on FreeBSD

2001-01-22 Thread Noor Dawod
Hi Sinisa Is the FreeBSD problem previously submitted by me known to you? Noor -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 3:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Unexplained high

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 they

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 problem is

Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Ken Menzel
[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 you? Noor Ken Manzel has submitted many valuable mess

Re: Unexplained high-loads on FreeBSD

2001-01-22 Thread Ken Menzel
] - 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, 2001 11:49 AM Subject: RE: Unexplained high-loads on Fre

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

RE: Unexplained high-loads on FreeBSD

2001-01-21 Thread Noor Dawod
D] 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-slow-queries[=file

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

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 Vibol Hou
ED]] Sent: Sunday, January 21, 2001 4:53 PM To: [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

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