On Fri, Aug 01, 2003 at 03:31:02PM +0100, Khaled D Elmeleegy wrote: > > I am studying the scalability of MYSQL on SMPs on Linux. I am > wondering if any one has performed scalability studies. If so, I > would be interested in a pointer to the results; if not, I am > curious if there is interest in MYSQL's scalability. Pointers to > benchmarks used to study MYSQL would also be appreciated. Another > thing I was wondering is if anyone had experience or recommendations > in choosing the server parameters of MYSQL to tune for SMP > performance.
MyISAM performance is limited right now by a global lock in the key cache. However, I believe there is work going on to fix that in the 4.1 tree. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 207,503,352 queries (399/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
