[root@vm-48 sysbench]# sysbench
|
--test=/root/sysbench/sysbench/tests/db/oltp.lua
|
--mysql-table-engine=innodb --oltp-table-size=10000 --max-requests=0
|
--max-time=60 --num-threads=100 --oltp-tables-count=1
|
--report-interval=10 --mysql-host=192.168.1.52 --mysql-port=3306
|
--mysql-user=admin --mysql-password=123456 --mysql-db=backend run
|
sysbench 0.5: multi-threaded system evaluation benchmark
|
|
Running the test with following options:
|
Number of threads: 100
|
Report intermediate results every 10 second(s)
|
Random number generator seed is 0 and will be ignored
|
|
Threads started!
|
|
ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5016' failed: 12701 Remote MySQL server has gone away
|
ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5004' failed: 12701 Remote MySQL server has gone away
|
ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5412' failed: 12701 Remote MySQL server has gone away
|
ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5004' failed: 12701 Remote MySQL server has gone away
|
ALERT: mysql_drv_query() for query 'SELECT c FROM sbtest1 WHERE id=5002' failed: 12701 Remote MySQL server has gone away
|
[root@vm-48 sysbench]#
|
[root@vm-48 sysbench]# mysql -h192.168.1.52 -uadmin -p123456 -e
|
"select count(*) from backend.sbtest1;"
|
+----------+
|
| count(*) |
|
+----------+
|
| 10000 |
|
+----------+
|
|
(root@localhost) [(none)]> select @@spider_version;
|
+------------------+
|
| @@spider_version |
|
+------------------+
|
| 3.2.19 |
|