Re: my.cnf optimization question ..

2001-09-12 Thread Jeremy Zawodny
On Tue, Sep 11, 2001 at 03:17:47PM -0500, Weslee Bilodeau wrote: > > > They average around 500 connections/second at any given time, two > > > have a master/slave setup. > > > > Connections/sec or Queries/sec? That's a lot of connections per > > second? Can you use persistent connections? It wo

Re: my.cnf optimization question ..

2001-09-11 Thread Weslee Bilodeau
> > They average around 500 connections/second at any given time, two > > have a master/slave setup. > > Connections/sec or Queries/sec? That's a lot of connections per > second? Can you use persistent connections? It would save a lot of > overhead. Half and half, at the moment .. We had a pro

Re: my.cnf optimization question ..

2001-09-10 Thread Jeremy Zawodny
On Mon, Sep 10, 2001 at 04:54:57PM -0500, Weslee Bilodeau wrote: > > Basic (maybe?) question on some optimal variables for MySQLd's my.cnf > configuration .. > > Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU > P3 1ghz. Nice. :-) > They average around 500 connections/second