Hank, I suspect some of the NetBSD threading comments you found in the archives may be mine.
We run NetBSD/Alpha for our site (motorsport.com) on the web server, our "work" server, plus several other boxes. We originally did the same for the database server, but, at the time (this being early 2000) MySQL appeared not to be happy on a 64-bit machine, at least on NetBSD. (I think this is now much better ...) So we switched to generic Intel hardware. And things ran OK, except that we had increasing numbers of MySQL restarts (5-20 times/day). Automatic, true, but they would always cause a delay in service, and we have a reasonably busy site -- we serve a few million pages per month, all database-driven. (I suspect threading issues, but I have no absolute proof of that.) So this past summer I switched to FreeBSD 4.3, on the same hardware, and moved the MySQL server over. I installed FreeBSD on the "new" server over FTP, added a preconfigured MySQL binary from http://www.freebsd.org/, and got it running in less than two hours. As a result, MySQL is now rock-solid. We run on a P3/750 on an ASUS motherboard with 384 MB of memory and IBM's 7200 rpm IDE disks. Right now the server uptime is 69+ days (I rebooted in October to change the hardware configuration), and the mysqld process (version 3.23.36) has since then accumulated some 250 hours of CPU time without a glitch. MySQL on NetBSD may have improved since last summer, but I can definitely vouch for FreeBSD at this point. The only question mark is the effectiveness of SMP -- I can't say anything about this, really, since we run on a single CPU. Configuring a dedicated MySQL server is straight-forward (much more so than a web server with integrated Apache and PHP or Apache::ASP). Once you have the OS and MySQL installed and tested, you should be able to just move your databases over, and point your web server at the remote database. Good luck with your choice ... Tom Haapanen [EMAIL PROTECTED] -----Original Message----- From: Henry Hank [mailto:[EMAIL PROTECTED]] Sent: 29 December 2001 01:18 To: [EMAIL PROTECTED] Subject: NetBSD versus RedHat versus Solaris x86 Hello all, I just ordered a new server to act as a database-only server for my website (wheresgeorge.com). I'm currently running mysql 3.22.29 (I'm stuck there due to my web hosting provider). I plan to upgrade to the latest stable version of mysql, but have the following questions about the choice of Operating System. The hardware is a Dell PowerEdge 2550 Dual 1GHZ Pentium/1GB Memory, 3x18GB SCSI disks and will be set up as RAID 5 via a PERC3/Di card. I also require large file size support (>2GB). My current database has over 16 million records and processes about 80 queries per second (on average). Peak usage could be around 300 queries/second (estimate). It is running on Linux on a dual PIII-800. Performance is very good, but I'm going to hit the 2GB limit soon, and need to expand beyond what my ISP can provide with their managed solutions. So I am going to co-locate this new DB server as a backend to the current webserver. On to the questions: I was considering Net/FreeBSD, but read about threading problems in the archives, so I don't know if they have been resolved. I was then thinking about RedHat7.2 with the 2.4 kernel (large file size support, I think). I then read about Solaris x86.. which is where I'm leaning, but I was told Solaris x86 might be slower than Linux of Free/NetBSD. I'm also thinking of installing Oracle 8i as a side-by-side comparison to mySQL running on the same HW/OS. Anyway, I'm not a UNIX whiz/admin by any stretch... I know enough to *NIX to manipulate files, jobs, processes, etc. I've even compiled a few packages in the past and got PHP/mysql installed and running on a linux box last year. I can write rudimentary shell scripts. I'm looking for general comments regarding the current status of any of these choices of OS on this hardware in relation to running a fast and stable mySQL installation. Are there any pitfalls I need to watch out for on any one OS? Is any one significantly more favorable for mysql that the other? As I've said, I have searched the archives, but can not find any real-current comments on OS selection. Thanks in advance, -Hank Eskin ([EMAIL PROTECTED]) __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php