PANIC: unprotected error in call to Lua API (cannot open
oltp: No such file or directory)
-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)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All
rights reserved.
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:
read: 11354
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'...
#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
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
