From owner-freebsd-hackers Thu Apr 26 1:42:49 2001 Delivered-To: freebsd-hackers@freebsd.org Received: from mime4.ccf.com (mail.ccf-sei.com [212.11.24.10]) by hub.freebsd.org (Postfix) with ESMTP id 0076737B423; Thu, 26 Apr 2001 01:42:44 -0700 (PDT) (envelope-from spetit@selectbourse.com) Received: from mime4.ccf.com (unverified) by mime4.ccf.com (Content Technologies SMTPRS 4.2.1) with SMTP id ; Wed, 25 Apr 2001 14:51:37 +0100 Received: from 10.44.201.51 by mime4.ccf.com (InterScan E-Mail VirusWall NT); Wed, 25 Apr 2001 14:51:36 +0100 (GMT Daylight Time) Received: by SBEXCHANGE with Internet Mail Service (5.5.2232.9) id ; Wed, 25 Apr 2001 14:44:55 +0200 Message-ID: From: PETIT Sebastien To: "'alfred@freebsd.org'" Cc: "'hackers@freebsd.org'" Subject: RE: Question about Posix Threads Date: Wed, 25 Apr 2001 14:44:54 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi, Is it the same limitation problem about the performance under mysql with a lot of IO ? I test FreeBSD-4.3 pthread and linux 2.2.16 pthread under same servers (ram, dd etc...) with mysql and same databases exactly. When I doing a request of about 57000 rows on a 4000000 rows database under linux I can have 1,70s of elapsed time and under FreeBSD, I have 2.89s for the same request. I see that Linux doing a lot of IO cache (buffered = 502556K and cached = 335160K, servers have 1 Go of memory) but FreeBSD limits to a little cache and 112 Mo buffered, the rest of memory is Free. I'm a FreeBSD fan, but I see that I cannot use FreeBSD for a mysql box production that do a lot of selects (index on memory doesn't change anything). I try to use softupdates but there is a little amelioration. Sinisa of mysql dev team says to me that reason lies in much more efficient context-switching, more efficient file system and much better buffering. So what is the difference about linux caching and FreeBSD ? is the vfs_bio architecure responsible of this lack of performance ? If someone can tell me how can I boost performance of caching under FreeBSD to have the same performance, please tell me :) If this problem is due to another problem and You know what is this problem tell me how too. I hope that FreeBSD can run mysql thread native as faster as possible in the future. Thank you for any clues. Regards, Sebastien Petit. -- spe@kestaklan.net > How is performance dismal under redhat? FreeBSD should do a really > good job of running thousands of threads as long as you don't have > too much disk IO since all the threads are multiplexed into a single > process, if you have an IO intensive program FreeBSD threads will > probably not help you all that much. There are plans on replacing > the FreeBSD threads library with a multiplexed userland<->kernel > scheme in the near future. > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message