Benchmarking and monitoring tools

Description

Benchmarking and
monitoring tools
Presented by, Section one:
MySQL & O’Reilly Media, Inc.
BenchmarkingBenchmarking tools and the like
mysqlslap
sql-bench
supersmack
Apache Bench (combined with some sample
PHP scripts)
MySQL’s benchmark() function
MyBench
WAST
JMetersql-bench
WHAT IS IT ?Presented by,
MySQL & O’Reilly Media, Inc.
SQL-BENCH is a collection of test scripts written in Perl that are
included in a MySQL install. In order to run them you just execute
the run-all-tests script in the mysql directory
In addition to could run individual test. SQL-BENCH
PROS
Ubiquitous
long history of use
CONS
Single thread
Perl
not always real-life test cases (create 10,000 tables ?)SQL-BENCH
More Details...
script Aim
test-alter-table Test of alter table
test-big-tables Test of extreme tables
test-create This test is for testing how long it takes to create tables, make a count(*) from them and finally
drop the tables.
test-select Test of selecting on keys that consist of many parts
test-ATIS Creation of 29 tables and a lot of selects on them.
test-connect This test is for testing the speed of connections and sending data to the client.
test-insert Test of creating a simple table and inserting $record_count records in it, $opt_loop_count
rows in order,$opt_loop_count rows in reverse order and $opt_loop_count rows in random
order. (opt_loop_count is 100000)
test-wisconsin This is a port of the PostgreSQL version of this benchmark (create ...

Sujets

• Testudo
• Structured Query Language
• Marc Wasterlain
• WWE SmackDown! (série de jeux vidéo)
• Application Web
• Prosnes

Informations

• Publié par: Idde
• Nombre de lectures: 73
• Langue: English

Extrait

rPseneet dyb, MySQL & O’Reilly Media, Inc. Benchmarking and monitoring tools Section one: Benchmarking

Benchmarking tools and the like ! ! ! ! ! ! ! !     mysqlslap     sql-bench     supersmack     Apache Bench (combined with some sample PHP scripts)     MySQL’s benchmark() function     MyBench     WAST     JMeter

Presented by, MySQL & O’Reilly Media, Inc. sql-bench WHAT IS IT ? i S n Q cl L u - d B e E d  N in C  a H    i M s  y a S  c Q o L ll  i e n c s t t io al n l.     o I f n     t o e r s d t  e s r c  t ri o p  r t u s  n w  t ri h tt e e m n     y in o   u P  j e u rl s   t t   h e a x t e  a c r u e t   e  the run-all-tests script in the mysql directory In addition to could run individual test.

SQL-BENCH ! ! SORP Ubiquitous long history of use SNOC Single thread lreP not always real-life test cases (create 10,000 tables ?)

SQL-BENCH ! More Details... script Aim test-alter-table Test of alter table test-big-tables Test of extreme tables test-create This test is for testing how long it takes to create tables, make a count(*) from them and finally  drop the tables. test-select Test of selecting on keys that consist of many parts test-ATIS Creation of 29 tables and a lot of selects on them. test-connect This test is for testing the speed of connections and sending data to the client. test-insert Test of creating a simple table and inserting $record_count records in it, $opt_loop_count  rows in order,$opt_loop_count rows in reverse order and $opt_loop_count rows in random order. (opt_loop_count is 100000) test-wisconsin This is a port of the PostgreSQL version of this benchmark (create and insert table from  Wisconsin directory)

SEUSSI http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html I ! P ! LRU ! ! SQL-BENCH  swodniw ni selbuort lre .ylno s'ortsid ecruos eb yam ti 1.5 n

SuperSmack ! Details Z O a ri w gi o n d a n ll y y     i d n e  h v i e s l   o fa pe m d o   u b s y     b S o a o s k h ,  a “   H P i a g c h h  P ev e , r   fo M r o m d a ifi n e c d e     e M xt y e S n Q si L v ” e M ly y  a S n Q d L     promoted by Jeremy  WHAT IS IT ? t S h u e p  a er p   a S c m he a   c b k e  i n s  c a h     b (a e b n ) c  t h o m ol a   r th ki a n t  g s ,  h s i t p r s e   s w s i   t t h e   s A ti p n a g c ,  h a e n ,  d s  l u o p a e d r    s ge m n a e c r k a   t h io el n p  t s o  t o o l    f g o i r v   e M  y y o S u Q  a L   . h  L a i n k d e l   e  on how well your server will perform. Compiled easily on my mac so should be portable. Flexible

SuperSmack ! sUga exemalp.e. super-smack -d mysql select-key.smack 50 1000 sudo /usr/local/bin/super-smack -d mysql select-key.smack 50 1000 Password: Query Barrel Report for client smacker1 connect: max=51ms min=33ms avg= 40ms from 50 clients Query_type num_queries max_time min_time q_per_s select_index 100000 10 0 5505.19    Time: 0   State: statistics    Info: select * from http_auth where username = 'omthglrulsxi82440' *************************** 5. row ***************************

SuperSmack ! ymqs>ls oh wufllp orecssilts\ G      Id: 575    User: test    Host: localhost      db: test Command: Query    Time: 0   State: statistics    Info: select * from http_auth where username = 'tkmpjihfegrq77160' *************************** 3. row ***************************      Id: 576    User: test    Host: localhost      db: test Command: Query    Time: 0   State: statistics    Info: select * from http_auth where username = 'cmcswrhugbsn1200' *************************** 4. row ***************************   

SuperSmack ! ! RPSO Launches concurrent connections so we are testing something more realistic than one thread creating a bazilliion queries SNOC ??

SuperSmack ! iDcssuisno b S e u n p c e h rS m m ar a k c in k  g i   s t   o w o e l. l . l     c d h o e c c u k m  it e   n o t u e t. d and a rather flexible