mysql-benchmark-4.1 results
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
This article about process timing
thanks very much for the help… i was wondering how do i test benchmark on the queries!!!
#!/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();
Thank you muchly
[see? randomly browsing forums CAN be productive]