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

MYSQL Scalability on SMPs

2003-08-01 Thread Khaled D Elmeleegy
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 al