On Thu, Dec 13, 2001 at 12:54:33PM +0100, Robert Sundström wrote: > > 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.
That shouldn't surprise anyone. There little if any contention in a single-user benchmark. > 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. Had you tuned InnoDB much at all, or were you using it out of the box? > 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. We've used it in an environment with hundreds (sometimes thousands) of queries per second and several "users" at once. The folks who know Oracle better than I are hard pressed to tell me that Oracle could do what MySQL is doing on the same hardware. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 15 days, processed 342,750,018 queries (251/sec. avg) --------------------------------------------------------------------- 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