From owner-freebsd-questions Thu Feb 15 2:27:56 2001 Delivered-To: freebsd-questions@freebsd.org Received: from post.mail.nl.demon.net (post-11.mail.nl.demon.net [194.159.73.21]) by hub.freebsd.org (Postfix) with ESMTP id 8598337B4EC for ; Thu, 15 Feb 2001 02:27:50 -0800 (PST) Received: from [212.238.47.90] (helo=bigfoot.com) by post.mail.nl.demon.net with esmtp (Exim 3.14 #4) id 14TLdc-0003We-00 for freebsd-questions@FreeBSD.ORG; Thu, 15 Feb 2001 10:27:49 +0000 Message-ID: <3A8BAEF0.1B5F991@bigfoot.com> Date: Thu, 15 Feb 2001 11:26:55 +0100 From: tr909 Reply-To: tr909@bigfoot.com X-Mailer: Mozilla 4.76 (Macintosh; U; PPC) X-Accept-Language: en MIME-Version: 1.0 To: freebsd-questions@FreeBSD.ORG Subject: MySQL much slower on FreeBSD vs Linux? References: <3A8928FC.907154B0@bigfoot.com> <3A893A5E.6A359EDC@staff.zeelandnet.nl> <3A893CBA.89E475E5@bigfoot.com> <3A893E07.CF759C3C@staff.zeelandnet.nl> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Dear BSD, I like mySQL very much especially on unix machines, but i ran across some disturbing posts that it would run twice as slow on FreeBSD as on a Linux box? I searched and searched all searchengines but could nowhere find a (recent) comparison of mysql bench results on the same hardware and different platforms (FreeBSD, Linux, Win98 etc.) On mysql.com there's also a comparison but on very different hardware and it appears to be a very old document (1997?) http://www.mysql.com/information/benchmark-results/result-mysql-platform-relative.html ------------------------------------ can you shed some light here? ------------------------------------ Thanks for your time, Gerhard (tr909) sources: http://lists.omnipotent.net/mysql/199904/msg00143.html (1999) http://zappa.zeelandnet.nl/article.php?sid=14&mode=thread&order=0 (2001) (the latter one is recent (in Dutch) but should pose no problem to read the specs) anwser by mysql: > We did recently setup a FreeBSD box here at MySQL; I will try to run > some benchmarks on it this weekend to be able to give you some > numbers! > > At any rate, everything indicates that on a multi-cpu machine MySQL is > much faster on Linux than on FreeBSD. > > Regards, > Monty Can some of the list readers and BSD Guru's shed some light here or maybe even give some hints to boost performance? as a bit newbie i am, i like BSD a bit more for security reasons but if it is allmost twice or three-times as slow with MySQL databases.... Gerhard To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message