Linode.com Forum

[metho]

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!!!

Quote: 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

[Xan]

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".

[metho]

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!!!

[Xan]

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

Code:
#!/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();

[cmantito]

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

Thank you muchly :)

[see? randomly browsing forums CAN be productive]