InnoDB my.cnf settings on OS X 10.3 Server?

2004-07-19 Thread Kieran Kelleher
I am trying to figure out the best innodb paramaters in the my.cnf file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with 2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am running on default params. Does anyone out there have a suggested innodb parameters or

Re: InnoDB my.cnf settings on OS X 10.3 Server?

2004-07-19 Thread Ware Adams
Kieran Kelleher wrote: Does anyone out there have a suggested innodb parameters or even a working set of params that I could start with. The InnoDB manual gives good suggestion. Some minor comments (none particularly OS X specific, but InnoDB works fine on it) innodb_buffer_pool_size is very

RE: InnoDB my.cnf settings on OS X 10.3 Server?

2004-07-19 Thread Lachlan Mulcahy
: InnoDB my.cnf settings on OS X 10.3 Server? I am trying to figure out the best innodb paramaters in the my.cnf file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with 2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am running on default params. Does anyone out