> ewen.fort...@gmail.com>
> >> >>> wrote:
> >> >>>>
> >> >>>> Johan,
> >> >>>>
> >> >>>> The very latest version of mk-log-player can do that.
> >> >>>> If you get the versio
t;> >>>>
>> >>>> Johan,
>> >>>>
>> >>>> The very latest version of mk-log-player can do that.
>> >>>> If you get the version from trunk:
>> >>>>
>> >>>> wget http://www.maatkit.org/trunk/mk
p.html
>
> Walter
>
> On Fri, Nov 13, 2009 at 22:33, Johan De Meersman
> wrote:
> > Hey all,
> >
> > I'm looking for a Mysql benchmarking/stresstesting tool that can generate
> a
> > workload based on standard Mysql full query log files. The idea is
Thread_id --type genlog
>
> Cheers,
>
> Ewen
>
> On Fri, Nov 13, 2009 at 4:33 PM, Johan De Meersman
> wrote:
> > Hey all,
> >
> > I'm looking for a Mysql benchmarking/stresstesting tool that can generate
> a
> > workload based on standard Mysql ful
;m looking for a Mysql benchmarking/stresstesting tool that can generate a
> workload based on standard Mysql full query log files. The idea is to verify
> performance of real production loads on various database setups.
>
> Does anyone know of such a tool, free or paying ?
>
> T
take a look at mysqlslap: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html
Walter
On Fri, Nov 13, 2009 at 22:33, Johan De Meersman wrote:
> Hey all,
>
> I'm looking for a Mysql benchmarking/stresstesting tool that can generate a
> workload based on standard Mysql full que
Hey all,
I'm looking for a Mysql benchmarking/stresstesting tool that can generate a
workload based on standard Mysql full query log files. The idea is to verify
performance of real production loads on various database setups.
Does anyone know of such a tool, free or paying ?
Thx,
Johan
Alex,
Thanks a bunch for the insight and for proving the links to the
following benchmarking tools. Unfortunately, business is requiring
that each database live in it's own instance, so it sounds like
moving in the direction of having multiple servers and spreading the
data around wou
whether all the databases can
live in the same MySQL instance and thus probably make better use of
the available RAM.
With regards to stress-testing and benchmarking, two popular tools for
benchmarking MySQL servers are:
Super Smack: http://vegan.net/tony/supersmack/
Sysbench: http://sysbench.sour
Guys,
System Configuration: Sun Microsystems sun4u Sun Fire E2900
System clock frequency: 150 MHZ
Memory size: 65536 Megabytes
CPU: 12 @ 1200 MHz
I'm looking for a tool that will allow us to determine the max number
of databases that can run in a single instance of MySQL on a pretty
beefy ser
Hello,
Does anybody know a Benchmarking GUI tool for MySQL under windows?
Thanks,
Mic
signature.asc
Description: OpenPGP digital signature
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 Z
Hi -
It's been a short while since I've seen any discussion on this subject,
and I'm wondering what's happened in this arena since then.
I'm curious as to what you guys use for benchmarking nowadays. I'd like
to benchmark preformance of an InnoDB database on a
also resulted in very similar results (results
not included in this message).
Load on machines was not noticeable at the time of benchmarking but machine
ONE is generally considered "more loaded" than machine TWO.
My questions have arisen from observations that in some results the
s not enogh?)
>
> Running bonnie++ on machines also resulted in very similar results (results
> not included in this message).
>
> Load on machines was not noticeable at the time of benchmarking but machine
> ONE is generally considered "more loaded" than machine T
ts (results
not included in this message).
Load on machines was not noticeable at the time of benchmarking but machine
ONE is generally considered "more loaded" than machine TWO.
My questions have arisen from observations that in some results the older
version of MySQL on "more l
I've just finished reading through most of the MySQL Enterprise
Solutions book by Alexander Pachev and I think you might want to take
a look at it. There is a section that deals with testing and MySQL
benchmarking tools.
These tools are available in the mysql/sql-bench (if your MySQ
use the benchmark suite and I would be
happy about any suggestions and instructions on how to perform a
detailed analysis of what MySQL is doing when my queries are processed.
Are there any tools? Would it be a good idea to write my own
benchmarking program?
b.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: "mixo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 08, 2003 11:21 A
How can I benchmark the perfomance of Mysql with the following setup:
Perl 5.8.0 (perl-DBI, perl-DBI-Mysql)
mysql-3.23.54a-11
apache-2.0.40-21
mod_perl-1.99_07-5
I want to compare the perfomance of Mysql against that of Pg using my
own data.
And, how can I resolve :
"DBD::mysql::st execute fa
Hi,
When I run "perl run-all-tests --server=mysql --cmp=mysql,pg,solid
--user=test --password=test --log" in the sql-bench direcotory. I
encountered following error messages:
" Can't locate DBI.pm in @INC (@INC contains:
/usr/lib/perl5/5.6.0/ia64-linux /usr/lib/perl5/5.6.0
/usr/lib
hi.
i'm trying to benchmark pgsql living in cygwin on a 2K box with mysql
installed normaly on windows. i get:
C:\mysql\bench>perl
run-all-tests --host=PAVILION --server=Pg --user=n
--password=x --log --comment "2x Pentium II 400mz, 256M, under
vmware"
Got error: 'connect
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
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 against other databases, I'm
interested in testing how my designs will perf
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 against other databases, I'm
interested in testing how my designs will perf
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
Dear all,
I've been trying benchmark MySQL, SQL Server 7, and M$ Access 97.
But, SQL Server 7 and M$ Access is won when connected and opening
recordset using ADO, Even i'm using MyODBC with TCP/IP connections.
If i'm use cursorlocation=serverside with adOpenDynamic, and adLockOptimistic,
still M
Does anyone know of any well-known Benchmarking tools for MYSQL database?
Thanks
S.M.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
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
How do I benchmark 2 queries that return same results
without having mysql read from cache?
Example:
if i run the first query it will take 2 seconds, when I run the query
again, it takes 0.05 seconds.
And
What is the max. size of the index file that fits into 512M memmory, so that
mysql doesn'
Thank you Dan!
I do not have access to a FreeBSD computer during this weekend but
your stack prints already tell the origin of the problem.
I have implemented my own mutexes in the purpose that I can use
an assembler instruction for the atomic test-and-set operation
needed in a mutex. But for no
In the last episode (Mar 30), Heikki Tuuri said:
> The FreeBSD bug is known. I will run tests on our FreeBSD machine in
> the next few days. Obviously there is something wrong with the
> FreeBSD port. Was it so that it hung and used 100 % of CPU? That has
> been reported also from Italy.
I have a
and auto_increament and grade as a key. There were 1 rows,
and I inserted the data using 'shell>mysql < data.sql'.
>2. Whenever I inserted the data, I simply did 'delete from table where no >
0' instead of dropping the table.
>2. I used 'my-medium' as
4-5.0, pentium550, 128 RAM, mysql-3.23.35
>complied with ./configure --with-charset=euc_kr --with-berkeley-db
--with-innobase
>
>
>Other setting
>1. The data used had three columns, 'no', 'name', 'grade' with 'no' as the
primary index and auto_incre
2. Whenever I inserted the data, I simply did 'delete from table where no > 0' instead
of dropping the table.
2. I used 'my-medium' as 'my.cnf'
'mysql insert' benchmarking result( all times are in seconds).
1. with key, autocommit=1, flush_log_at_trx=1, all
Hello Heikki,
Monday, March 19, 2001, 4:40:30 PM, you wrote:
>>Also the problem with innobase_flush_log_at_trx_commit=0 should be
>>there is no guarantie the last transaction commited will be on it's
>>place if the power would be lost. Also I don't know is it possible in
>>this case for databa
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
Hello Christian,
Sunday, March 18, 2001, 12:22:44 PM, you wrote:
>>
>>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
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
Hello
I've compiled mysql-3.23.35 with innobase support - it runs much
better than BDB for me - and run a simple benchmark with the
following script:
use DBI;
my $DB= DBI->connect("dbi:mysql:innobase","chris",shift) or die;
$DB->{RaiseError}=1;
$DB->do("drop table if exists speedtest");
$DB->d
Hi,
My website is running on MySql 3.21 and it has so much records that it sometimes
stopped running and
I had to restart the mysqld.
My question is how do I go about benchmarking my site and the mysql server?
TIA
Teddy
42 matches
Mail list logo
