Re: Benchmarking/optimization of MySQL

2004-03-02 Thread Sasha Pachev
Bostjan Skufca (at) domenca.com wrote: Hello, for the last few days I've been running benchmarks from sql-bench directory and tunning server parameters and I have few questions. Firstly I would like to note that benchmarks were run on two different but similar machines: Machine ONE: Dual Xeo

Re: Benchmarking/optimization of MySQL

2004-03-02 Thread Peter Zaitsev
On Tue, 2004-03-02 at 19:00, Bostjan Skufca (at) domenca.com wrote: Bostjan, At first I shall mention you have set up your experiment the hardest way for comments. You have different hardware, different MySQL versions and different MySQL settings. Normally you would like to change only one of t

Benchmarking/optimization of MySQL

2004-03-02 Thread Bostjan Skufca (at) domenca.com
Hello, for the last few days I've been running benchmarks from sql-bench directory and tunning server parameters and I have few questions. Firstly I would like to note that benchmarks were run on two different but similar machines: Machine ONE: Dual Xeon 2.4 533MHz FSB 4GB RAM SCSI raid 10 (