Comment 14 for bug 1349915

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Checked in PXC 5.6.20 (testing) with sysbench 0.5, table_open_cache_instances=8 and writing in all nodes. I couldn't reproduce that error. Sharing one of node result here.

[root@percona-pxc56-1 db]# sysbench --test=/usr/share/doc/sysbench/tests/db/insert_autoinc.lua --oltp-table-size=100000 --oltp-tables-count=1 --num-threads=256 --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=root --mysql-port=3306 --report-interval=1 --max-requests=0 --max-time=180 run
sysbench 0.5: multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 256
Report intermediate results every 1 second(s)
Random number generator seed is 0 and will be ignored

Threads started!

[ 1s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 38.76, response time: 913.27ms (95%)
[ 2s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 42.00, response time: 1922.71ms (95%)
[ 3s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 36.99, response time: 2847.57ms (95%)
[ 4s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 37.00, response time: 3864.34ms (95%)
[ 5s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 24.00, response time: 4527.38ms (95%)
[ 6s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 6.00, response time: 5900.62ms (95%)
...
[ 184s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 0.00, response time: 0.00ms (95%)
[ 185s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 39.00, response time: 9345.01ms (95%)
[ 186s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 28.00, response time: 8206.52ms (95%)
[ 187s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 45.00, response time: 12341.02ms (95%)
[ 188s] threads: 256, tps: 0.00, reads/s: 0.00, writes/s: 48.00, response time: 12583.49ms (95%)
OLTP test statistics:
    queries performed:
        read: 0
        write: 5311
        other: 0
        total: 5311
    transactions: 0 (0.00 per sec.)
    deadlocks: 0 (0.00 per sec.)
    read/write requests: 5311 (28.24 per sec.)
    other operations: 0 (0.00 per sec.)

General statistics:
    total time: 188.0751s
    total number of events: 5311
    total time taken by event execution: 47228.6313s
    response time:
         min: 17.63ms
         avg: 8892.61ms
         max: 15962.30ms
         approx. 95 percentile: 12337.32ms

Threads fairness:
    events (avg/stddev): 20.7461/0.55
    execution time (avg/stddev): 184.4868/2.44

[root@percona-pxc56-1 db]#