mysql-benchmark-4.1 results

hello how you all doing?

i have this question regarding the mysql-benchmark-4.1!

mysql-server-4.1 and benchmark was installed to determine the performance of a system or rather an OS, installation and all other relevent stuff went OK!!! but now i am running these mysql benchmark scritpts and they are producing random outputs (results) which i am not sure how to to measure them!!!

> metho@ubuntu:~/Desktop/mysql-4.1.18/sql-bench$ ./test-wisconsin –server=mysql –log

Testing server 'MySQL 4.1.12 Debian_1ubuntu3.1 log' at 2006-04-03 19:17:21

Wisconsin benchmark test

Time for create_table (3): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)

Inserting data

Time to insert (31000): 3 wallclock secs ( 0.57 usr 0.24 sys + 0.00 cusr 0.00 csys = 0.81 CPU)

Time to delete_big (1): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)

Running the actual benchmark

Time for wisc_benchmark (114): 2 wallclock secs ( 1.36 usr 0.39 sys + 0.00 cusr 0.00 csys = 1.75 CPU)

Total time: 5 wallclock secs ( 1.93 usr 0.63 sys + 0.00 cusr 0.00 csys = 2.56 CPU)

metho@ubuntu:~/Desktop/mysql-4.1.18/sql-bench$ ls -l

could someone who'v had experienced with mysql benchmark tell me what these rendom figures+numbers mean and how can i measure them i.e.

what does 3 wellclock means (normal secs)

0.57 usr means???

0.24 sys mean??

0.00 cusr means???

0.00 csys means???

1.75 CPU???

thanks very much in advance!!!!

-mEtho

4 Replies

Whoa, there! Try to calm down; it'll do you a world of good. :)

This article about process timing from IBM may help you. "real" == "wallclock".

i thought i was calmed down after watching baywatch!!! lol…

thanks very much for the help… i was wondering how do i test benchmark on the queries!!!

Well I normally am using mysql through Perl, so I do it this way:

#!/usr/bin/perl

use strict;
use DBI;
use Benchmark ':hireswallclock';

my $dbh = DBI->connect (
           'DBI:mysql:host=localhost;database=databasename',
           'username', 'password') or die $!;

my $start = new Benchmark;
#whatever queries you want to run here
my $end = new Benchmark;

my $diff = timediff($end,$start);
warn "task (whatever) completed in: ".timestr($diff);

$dbh->disconnect();

Oooh… That could be really really useful to me in the near future…

Thank you muchly :)

[see? randomly browsing forums CAN be productive]

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct