At 04:23 2001-12-02 , you wrote: >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.
I have done some admittedly not-so-scientific testing on MySQL (both with MyISAM and InnoDB) to find that both combinations performs best in single user systems. The test I run made about 50% updates/inserts and about 50% queries, with medium sized transactions (3-5 statements per transaction, where transactions was supported). On my regular desktop box I was able to get about 700 statements per second using MyISAM and about two thirds of that using InnoDB. Already at 2 simultaneous users (doing the same transactions) total throughput was less than for the single user case. Most stable commercial products exposes the opposite behavior. It may be the case that MySQL performs pretty well in single (or few) user cases, but the commercial alternatives will, in my experience, in most cases beat MySQL on 3-5 users and above. It is also the case that most commercial products supports better optimization methods than MySQL. Two important things are caching statement compilations at the server and stored procedures. If I have a performance problem in my database it is often the case that I can improve things by putting some SQL-code in a stored procedure. --------------------------------------------------------------------- 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
