root@djen:~/lolo# cat sysbench_cluster.sh
#!/bin/bash
if [ "x$1" == "x" ]
then
echo "You must specify the command to run : prepare / run / cleanup."
exit
fi
sysbench --num-threads=32 --max-requests=10000 --test=oltp --oltp-table-size=1000000 --oltp-test-mode=complex --oltp-reconnect-mode=query --mysql-host=172.16.29.238 --mysql-user=cluster --mysql-password=blabla --mysql-port=3309 --oltp-skip-trx --mysql-table-engine=innodb $1
root@djen:~/lolo# ./sysbench_cluster.sh cleanup
sysbench 0.4.12: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
Dropping table 'sbtest'...
Done.
root@djen:~/lolo# ./sysbench_cluster.sh prepare
sysbench 0.4.12: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
Creating table 'sbtest'...
Creating 1000000 records in table 'sbtest'...
root@djen:~/lolo# ./sysbench_cluster.sh run
sysbench 0.4.12: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
Running the test with following options:
Number of threads: 32
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Skipping BEGIN/COMMIT
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
(last message repeated 1 times)
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
FATAL: unable to connect to MySQL server, aborting...
FATAL: error 2003: Can't connect to MySQL server on '172.16.29.238' (99)
FATAL: failed to connect to database server!
Done.
OLTP test statistics:
queries performed:
read: 24556
write: 8770
other: 28064
total: 61390
transactions: 1754 (49.26 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 33326 (935.86 per sec.)
other operations: 28064 (788.09 per sec.)
./sysbench_cluster.sh: line 9: 11905 Erreur de segmentation sysbench --num-threads=32 --max-requests=10000 --test=oltp --oltp-table-size=1000000 --oltp-test-mode=complex --oltp-reconnect-mode=query --mysql-host=172.16.29.238 --mysql-user=cluster --mysql-password=blabla --mysql-port=3309 --oltp-skip-trx --mysql-table-engine=innodb $1