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

RE: Unexplained high-loads on FreeBSD

2001-01-21 Thread Noor Dawod
Hello Jan and all, I have issued a "show processlist" all the time during the time that mysqld is at high loads, but I didn't notice slow queries of some kind. Furthermore, I personally go over all queries and tables produced by our developers to insure proper syntax and indexing, so I am pretty

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
Hi, I've read from the FreeBSD SMP kernel developer's list that the FreeBSD threads implementation is not as mature as Linux is. Even then, either OS' thread implementations are not as mature as commercially available systems. It was suggested that Solaris be used for mysql. -- Vibol Hou

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