[B]Hello,
I’m making performance on the server that contains the PXC test, this test was performed with the cluster apart and with only the default settings of and PXC Galera. [/B]
When I run with the library Sysbench Galera enabled in my.cnf got the result:
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 8
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using “BEGIN” for starting transactions
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting…
(last message repeated 7 times)
Done.
OLTP test statistics:
queries performed:
read: 43442
write: 15515
other: 6206
total: 65163
transactions: 3103 (51.57 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 58957 (979.90 per sec.)
other operations: 6206 (103.15 per sec.)
Test execution summary:
total time: 60.1664s
total number of events: 3103
total time taken by event execution: 480.7706
per-request statistics:
min: 78.81ms
avg: 154.94ms
max: 473.67ms
approx. 95 percentile: 278.12ms
Threads fairness:
events (avg/stddev): 387.8750/0.33
execution time (avg/stddev): 60.0963/0.04
And when I run without activating the library’s Galley, the result is:
Running the test with following options:
Number of threads: 8
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using “BEGIN” for starting transactions
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting…
(last message repeated 7 times)
Done.
OLTP test statistics:
queries performed:
read: 158060
write: 56450
other: 22579
total: 237089
transactions: 11289 (188.02 per sec.)
deadlocks: 1 (0.02 per sec.)
read/write requests: 214510 (3572.67 per sec.)
other operations: 22579 (376.05 per sec.)
Test execution summary:
total time: 60.0419s
total number of events: 11289
total time taken by event execution: 479.9464
per-request statistics:
min: 21.18ms
avg: 42.51ms
max: 1740.17ms
approx. 95 percentile: 71.28ms
* How do I add a library crowd:
wsrep_provider=/usr/lib64/libgalera_smm.so