MySQL and SQL Server: Sysbench 0.5 on CENTOS7

[root@centos7 home]# wget http://www.lefred.be/files/sysbench-0.5-3.el6_.x86_64.rpm

[root@centos7 home]# ls -lah

-rw-r--r--. 1 root root 180K Jan 18 2013 sysbench-0.5-3.el6_.x86_64.rpm

[root@centos7 home]# rpm -ivh sysbench-0.5-3.el6_.x86_64.rpm

Preparing... ################################# [100%]

Updating / installing...

1:sysbench-0.5-3.el6 ################################# [100%]

[root@centos7 home]# sysbench --test=oltp help

sysbench 0.5: multi-threaded system evaluation benchmark

PANIC: unprotected error in call to Lua API (cannot open oltp: No such file or directory)

[root@centos7 home]# ll /usr/share/doc/sysbench/tests/db

total 44

-rw-r--r--. 1 root root 3585 Sep 7 2012 common.lua

-rw-r--r--. 1 root root 340 Sep 7 2012 delete.lua

-rw-r--r--. 1 root root 830 Sep 7 2012 insert.lua

-rw-r--r--. 1 root root 2925 Sep 7 2012 oltp.lua

-rw-r--r--. 1 root root 342 Sep 7 2012 oltp_simple.lua

-rw-r--r--. 1 root root 425 Sep 7 2012 parallel_prepare.lua

-rw-r--r--. 1 root root 343 Sep 7 2012 select.lua

-rw-r--r--. 1 root root 3964 Sep 7 2012 select_random_points.lua

-rw-r--r--. 1 root root 4066 Sep 7 2012 select_random_ranges.lua

-rw-r--r--. 1 root root 343 Sep 7 2012 update_index.lua

-rw-r--r--. 1 root root 552 Sep 7 2012 update_non_index.lua

[root@centos7 home]#

[root@centos7 db]# sysbench --test='/usr/share/doc/sysbench/tests/db/oltp.lua' --oltp_tables_count=100 --report-interval=10 --oltp-table-size=1000 --num-threads=2 --mysql-user=root --mysql-password=123123 --mysql-table-engine=innodb --rand-init=on --mysql-host=192.168.1.144 --mysql-port=3306 --mysql-db=oltp prepare

sysbench 0.5: multi-threaded system evaluation benchmark

Creating table 'sbtest1'...

Inserting 1000 records into 'sbtest1'

Creating table 'sbtest2'...

…………………………………………………………

Inserting 1000 records into 'sbtest98'

Creating table 'sbtest99'...

Inserting 1000 records into 'sbtest99'

Creating table 'sbtest100'...

Inserting 1000 records into 'sbtest100'

[root@centos7 db]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.6.11 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| oltp |

| performance_schema |

| test |

+--------------------+

5 rows in set (0.01 sec)

mysql> use oltp;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

+----------------+

| Tables_in_oltp |

+----------------+

| sbtest1 |

| sbtest10 |

| sbtest100 |

[root@centos7 db]# sysbench --test='/usr/share/doc/sysbench/tests/db/oltp.lua' --oltp_tables_count=100 --report-interval=5 --oltp-table-size=100 --mysql-user=root --mysql-password=123123 --oltp-connect-delay=10 --oltp-dist-type=uniform --rand-init=on --mysql-table-engine=innodb --mysql-host=192.168.1.144 --mysql-port=3306 --mysql-db=oltp --max-time=15 --max-requests=0 --num-threads=6 --thread-stack-size=256 run

sysbench 0.5: multi-threaded system evaluation benchmark

Running the test with following options:

Number of threads: 6

Report intermediate results every 5 second(s)

Initializing random number generator from timer.

Random number generator seed is 0 and will be ignored

Threads started!

[ 5s] threads: 6, tps: 53.62, reads/s: 767.42, writes/s: 219.26, response time: 137.18ms (95%)

[ 10s] threads: 6, tps: 53.60, reads/s: 750.38, writes/s: 214.40, response time: 160.24ms (95%)

[ 15s] threads: 6, tps: 53.80, reads/s: 753.18, writes/s: 215.19, response time: 139.92ms (95%)

OLTP test statistics:

queries performed:

write: 3244

other: 1622

total: 16220

transactions: 811 (53.68 per sec.)

deadlocks: 0 (0.00 per sec.)

read/write requests: 14598 (966.31 per sec.)

other operations: 1622 (107.37 per sec.)

General statistics:

total time: 15.1069s

total number of events: 811

total time taken by event execution: 90.3482s

response time:

min: 49.34ms

avg: 111.40ms

max: 202.72ms

approx. 95 percentile: 144.47ms

Threads fairness:

events (avg/stddev): 135.1667/1.07

execution time (avg/stddev): 15.0580/0.04

[root@centos7 db]# sysbench --test='/usr/share/doc/sysbench/tests/db/oltp.lua' --oltp_tables_count=100 --report-interval=5 --oltp-table-size=100 --mysql-user=root --mysql-password=123123 --mysql-table-engine=innodb --mysql-host=192.168.1.144 --mysql-port=3306 --mysql-db=oltp cleanup

sysbench 0.5: multi-threaded system evaluation benchmark

Dropping table 'sbtest1'...

Dropping table 'sbtest2'...

…………………………………

Dropping table 'sbtest99'...

Dropping table 'sbtest100'...

[root@centos7 db]#

#initinal script

sysbench --test='/usr/share/doc/sysbench/tests/db/oltp.lua' --oltp_tables_count=100 --report-interval=10 --oltp-table-size=1000 --num-threads=2 --mysql-user=root --mysql-password=123123 --mysql-table-engine=innodb --rand-init=on --mysql-host=192.168.1.144 --mysql-port=3306 --mysql-db=oltp prepare

#stress test script

sysbench --test='/usr/share/doc/sysbench/tests/db/oltp.lua' --oltp_tables_count=100 --report-interval=5 --oltp-table-size=100 --mysql-user=root --mysql-password=123123 --oltp-connect-delay=10 --oltp-dist-type=uniform --rand-init=on --mysql-table-engine=innodb --mysql-host=192.168.1.144 --mysql-port=3306 --mysql-db=oltp --max-time=15 --max-requests=0 --num-threads=6 --thread-stack-size=256 run

#clean script

MySQL and SQL Server

Thursday 28 August 2014

Sysbench 0.5 on CENTOS7

No comments:

Post a Comment