Announcement

Announcement Module
Collapse
No announcement yet.

Overload Galera in Percona

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Overload Galera in Percona

    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.


    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

Working...
X