20120814_sysbench_outputs

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