Not sure that total users is a good metric; queries per second may be better.
We host web sites and use MySQL with MyISAM tables for small and medium-sized sites, Oracle for the big ones. Oracle's row-level locking abilities make a big, deciding difference for the bigger, more active sites. Oracle just scales much better than MySQL. Big downside of Oracle is the price, which is why we use it for just the big boys. Costs too much to install on all our servers. I'm currently evaluating Berkeley and InnoDB tables to see how they compare to Oracle. If they compare well then we may be using'em in place of Oracle for most sites. Thanks, --Walt Weaver Bozeman, Montana -----Original Message----- From: Philip Mak To: MySQL Mailing List Sent: 11/30/2001 8:59 PM Subject: MySQL v.s. Oracle Hi all, We are currently using MySQL for our database driven website. Currently, we have about 100,000 users. In January, we will be getting 2 million new registered users on our website. We're buying a $50,000 Sun box to run the database server on. We're deciding whether we should switch to Oracle. Can MySQL handle this kind of load? The president (who doesn't know much about databases) was thinking about buying Oracle, but from what I've heard, Oracle is actually slower than MySQL since it needs to check FOREIGN KEYs, TRIGGERs, ASSERTIONs, etc. Can someone provide some advice? Thanks. My main concern is whether that massive scale (2 million registered users, along with all the data and CPU load they generate) is supported by MySQL. --------------------------------------------------------------------- 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
