Also make sure that your MySQL is not 5.1.23 from packages
or ports. I 
had an issue with the sorting of large result sets losing
rows. I had 
the issue on both i386 and amd64. DBMail did all kinds a
weird things 
such as messages not showing up at all when headers were
downloaded.

I'm glad that the new kernel is working better.

-Jon

khanh.truong1800GOTJUNK.COM wrote:
> Thanks Jon and all others for your great suggestions.
>
> As Jon said, I'm drawing towards the conclusion that
the issue was with some bug or incompatibility between
FreeBSD 7 and MySql 5.1. FreeBSD 7 has a new scheduler but
by default it still uses the older one. Things seemed to be
much better after we recompiled the kernel with the new
scheduler.
>
>   
>> Also - My custom kernel config has to following
non-standard options
>>     
>
>   
>> options         HZ=2000
>> options         SCHED_ULE               # ULE
scheduler
>> options         PREEMPTION              # Enable
kernel thread preemption
>> options         FULL_PREEMPTION         # Enable
kernel thread preemption
>> options         IPI_PREEMPTION          # Enable
kernel thread preemption
>> options         SMP
>>     
>
> Khanh
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
>   



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail