Linode Forum
Linode Community Forums 		 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic

Board index » Linux Community Forums » Web Servers and Web App Development
  Previous topic | Next topic 
Author Message
metho
PostPosted: Mon Apr 03, 2006 3:30 pm 
Offline
Newbie

Joined: Mon Apr 03, 2006 3:24 pm
Posts: 2
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
Top
   
Reply with quote  
Xan
 Post subject:
PostPosted: Mon Apr 03, 2006 3:42 pm 
Offline
Senior Member
User avatar

Joined: Sun Feb 08, 2004 7:18 pm
Posts: 562
Location: Austin
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".
Top
   
Reply with quote  
metho
 Post subject:
PostPosted: Mon Apr 03, 2006 3:50 pm 
Offline
Newbie

Joined: Mon Apr 03, 2006 3:24 pm
Posts: 2
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!!!
Top
   
Reply with quote  
Xan
 Post subject:
PostPosted: Mon Apr 03, 2006 3:55 pm 
Offline
Senior Member
User avatar

Joined: Sun Feb 08, 2004 7:18 pm
Posts: 562
Location: Austin
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();
Top
   
Reply with quote  
cmantito
 Post subject:
PostPosted: Mon Apr 03, 2006 8:12 pm 
Offline
Senior Newbie

Joined: Thu Oct 06, 2005 8:55 am
Posts: 17
ICQ: 127444488
Website: http://kevinsnet.com
WLM: msnmsgr@compalumpa.org
Yahoo Messenger: cm00tito
AOL: cm00tito
Location: NJ USA
Oooh... That could be really *really* useful to me in the near future...

Thank you muchly :)

[see? randomly browsing forums CAN be productive]

_________________
Kevin C. Leacock
cmantito 'at' cmantito 'dot' com

"A train station is where a train stops. A bus station is where a bus stops. On my desk I have a workstation..."
Top
   
Reply with quote  
Display posts from previous:  Sort by  
Post new topic  Reply to topic

Board index » Linux Community Forums » Web Servers and Web App Development


Who is online

Users browsing this forum: No registered users and 4 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group