Dan Trainor wrote:
I'm curious as to what you guys use for benchmarking nowadays. I'd like
to benchmark preformance of an InnoDB database on a fancy new server,
compared to an old degraded one.
Hi Dan!
I use SysBench for most things, also MyBench for a few things (from
Jeremy Zawodny) as we
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
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
Mixo,
you have to add another InnoDB data file. Also adjust other InnoDB
parameters in my.cnf to get a good performance.
http://www.innodb.com/ibman.html#InnoDB_start
"
An advanced my.cnf example. Suppose you have a Linux computer with 2 GB RAM
and three 60 GB hard disks (at directory paths `/',
Sounds good. Thanks for the info, Heikki.
--Walt
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Benchmarking MyISAM, InnoDB, and Oracle: a problem with
InnoDB
Walt,
this is probably a
On Mon, 24 Dec 2001 12:37:21 -0800, Joel Wickard used a
few recycled electrons to form:
| Hello,
| I've looked around on mysql.com, and through the directories of my mysql
| install I'm looking for information on benchmarking my mysql database, but
| I'm not interested in seeing how it performs ag
Hi,
> -Original Message-
> From: Rachman M.H [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 18, 2001 11:02 PM
> To: [EMAIL PROTECTED]
> Subject: Benchmarking
>
>
> Dear all,
>
> I've been trying benchmark MySQL, SQL Server 7, and M$ Access 97.
> But, SQL Server 7 and M$ Access is
On Mon, Aug 13, 2001 at 05:54:35PM +0100, Tadej Guzej wrote:
> How do I benchmark 2 queries that return same results without having
> mysql read from cache?
The only certain way is to restart the server between the queries and
do what you can to flush the OS cache, too, if you're concerned about
Hi Peter and Christian!
>>If you are going to be committing on every record, you'll want your
>>tablespace and logfile directories on separate disks to avoid
>>thrashing. If you only have one disk and don't care if you lose the
>>last few transactions if your system crashes, try setting
>>innoba
At 20:43 Uhr -0600 17.3.2001, Dan Nelson wrote:
>In the last episode (Mar 17), Christian Jaeger said:
>> innobase table:
> > autocommit=0, rollback after each insert: 59 insert+rollback/sec.
>> autocommit=0, one rollback at the end: 2926 inserts/sec.
>> autocommit=0, one commit at the e
10 matches
Mail list logo
