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