← Back to branch summary

~linuxjedi/drizzle/trunk-bug-667053

« back to all changes in this revision

Viewing changes to storage/archive/support/archive_read_test.slap

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
storage/archive/support/archive_read_test.slap
 
1
#!/bin/bash
 
2
 
 
3
# Script I use to look at aio performance --Brian
 
4
 
 
5
MYSQLSLAP="/home/mysql/trees/mysql-5.2-arch/client/mysqlslap --protocol=tcp"
 
6
CONCURRENCY="1,25,50,75,100,125,150,175,200,225,250,275,300"
 
7
ENGINE="archive"
 
8
 
 
9
 
 
10
cp /dev/null /tmp/$ENGINE-scan-scale.csv
 
11
cp /dev/null /tmp/$ENGINE-key-scale.csv
 
12
 
 
13
$MYSQLSLAP --concurrency=$CONCURRENCY --iterations=10 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --csv=/tmp/$ENGINE-key-scale.csv --engine=$ENGINE --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=key --auto-generate-sql-execute-number=1000 --burnin
 
14
 
 
15
# read()
 
16
 
 
17
$MYSQLSLAP --concurrency=$CONCURRENCY --iterations=10 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --csv=/tmp/$ENGINE-scan-scale.csv --engine=$ENGINE --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=read --auto-generate-sql-execute-number=1000 --pre-query="SET GLOBAL archive_aio=OFF;" --burnin
 
18
 
 
19
$MYSQLSLAP --concurrency=$CONCURRENCY --iterations=10 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --csv=/tmp/$ENGINE-key-scale.csv --engine=$ENGINE --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=key --auto-generate-sql-execute-number=1000 --pre-query="SET GLOBAL archive_aio=OFF;"
 
20
 
 
21
# aio_read()
 
22
 
 
23
$MYSQLSLAP --concurrency=$CONCURRENCY --iterations=10 --number-int-cols=2
 
24
--number-char-cols=3 --auto-generate-sql --csv=/tmp/$ENGINE-key-scale.csv --engine=$ENGINE --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=key --auto-generate-sql-execute-number=1000
 
25
 
 
26
$MYSQLSLAP --concurrency=$CONCURRENCY --iterations=10 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --csv=/tmp/$ENGINE-scan-scale.csv --engine=$ENGINE --auto- generate-sql-add-autoincrement --auto-generate-sql-load-type=read --auto-generate-sql-execute-number=1000