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

my.cnf optimization question ..

2001-09-10 Thread Weslee Bilodeau
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. They average around 500 connections/second at any given time, two have a master/slave setup. MySQL is prettty much the only thing r