Re: MYSQL Scalability on SMPs
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]
RE: MYSQL Scalability on SMPs
> It looks like Igor comitted it to the 4.1 tree on the 2nd of this month: I'd assume that this change is necessary but not sufficient for the MySQL table type table locking issue... I know, I know, there is InnoDB for that, but there are reasons not to use it despite this particular wonderful advantage. --steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Scalability on SMPs
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremy Zawodny wrote: > On Thu, Aug 07, 2003 at 10:27:38PM -0700, Steven Roussey wrote: > >>>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. >> >>Really? I thought it was going to be fixed in the 5.1 tree, which will >>be years away from production quality. 4.1 would be really cool, but it >>seems so soon (non-InnoDB)... > > > I'm pretty sure the multi-keycache code is in 4.1, but I'd have to > scan the checkins to be sure. It might have been 5.0 but I'm > virtually certain I saw it... > > Jeremy It looks like Igor comitted it to the 4.1 tree on the 2nd of this month: ChangeSet 1.1553 03/08/02 02:43:18 [EMAIL PROTECTED] +43 -0 Many files: Added key cache assignment mi_locking.c: Added key cache assignment: correction my_sys.h: Added key cache variable structure Monty hasn't done the code review of any of the recent commits to 4.1 (he's almost finished with 4.0 it looks like) yet, so my guess is this should be going into 4.1.1. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/M6V8tvXNTca6JD8RAld0AKDFgLCoJoMO0Cl+qKxVuDX6lypAvQCdGzrV e6DjTvJ3lFauYaUDnJTeWVk= =Z6nn -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Scalability on SMPs
On Fri, Aug 08, 2003 at 09:25:31AM -0700, Steven Roussey wrote: > > It looks like Igor comitted it to the 4.1 tree on the 2nd of this > month: > > I'd assume that this change is necessary but not sufficient for the > MySQL table type table locking issue... What issue is that? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 7 days, processed 252,599,677 queries (399/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Scalability on SMPs
On Thu, Aug 07, 2003 at 10:27:38PM -0700, Steven Roussey wrote: > > 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. > > Really? I thought it was going to be fixed in the 5.1 tree, which will > be years away from production quality. 4.1 would be really cool, but it > seems so soon (non-InnoDB)... I'm pretty sure the multi-keycache code is in 4.1, but I'd have to scan the checkins to be sure. It might have been 5.0 but I'm virtually certain I saw it... Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 223,356,851 queries (394/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL Scalability on SMPs
> 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. Really? I thought it was going to be fixed in the 5.1 tree, which will be years away from production quality. 4.1 would be really cool, but it seems so soon (non-InnoDB)... --steve- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]