# Overload Galera in Percona

**URL:** https://forums.percona.com/t/overload-galera-in-percona/3352
**Category:** Percona XtraDB Cluster 5.x
**Created:** [March 21, 2014, 8:11am UTC](https://forums.percona.com/t/overload-galera-in-percona/3352 "2014-03-21T08:11:45Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![fonsecacassio](https://avatars.discourse-cdn.com/v4/letter/f/7cd45c/32.png) [@fonsecacassio](https://forums.percona.com/u/fonsecacassio)
#### Post date: [March 21, 2014, 8:11am UTC](https://forums.percona.com/t/overload-galera-in-percona/3352/1 "2014-03-21T08:11:45Z")

</div>

[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