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 (

Re: Optimization of MySQL

2001-05-02 Thread Jeremy Zawodny
On Wed, May 02, 2001 at 08:40:10AM +0200, Warren van der Merwe wrote: > Hi there > > Is there anything similar to this that will run on a Windows platform? As luck would have it, yes. I managed to get mytop working on Windows today. There are a few rough edges, but with about 20 minutes more wor

RE: Optimization of MySQL

2001-05-01 Thread Warren van der Merwe
nal Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > ]On Behalf > Of Jeremy Zawodny > Sent: 02 May 2001 07:30 > To: Bryan Coon > Cc: '[EMAIL PROTECTED]' > Subject: Re: Optimization of MySQL > > > On Tue, May 01, 2001 at 04:46:39PM -0700, Br

Re: Optimization of MySQL

2001-05-01 Thread Jeremy Zawodny
On Tue, May 01, 2001 at 04:46:39PM -0700, Bryan Coon wrote: > > Our database is large, and getting larger, with several tables > approaching the 1gig mark. In addition, the database will be moving > to a dedicated node on a beowulf cluster. Cool... :-) > For our users, we are not particulary i

Optimization of MySQL

2001-05-01 Thread Bryan Coon
Hi, I am running a MySQL server on a nice machine (dual pIII 1gHz/1g ram), with RedHat 7.0. Currently, I am using the rpm version of mysql, which is 3.23.37. Our database is large, and getting larger, with several tables approaching the 1gig mark. In addition, the database will be moving to