Re: MYSQL Scalability on SMPs

2003-08-14 Thread Jeremy Zawodny
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 i

RE: MYSQL Scalability on SMPs

2003-08-14 Thread Steven Roussey
> 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 ad

Re: MYSQL Scalability on SMPs

2003-08-14 Thread Mark Matthews
-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. >> >>

Re: MYSQL Scalability on SMPs

2003-08-14 Thread Jeremy Zawodny
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

Re: MYSQL Scalability on SMPs

2003-08-08 Thread Jeremy Zawodny
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

Re: MYSQL Scalability on SMPs

2003-08-07 Thread Steven Roussey
> 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 se