Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18080

Run MyRocks benchmark: MariaDB vs Percona Server vs FB/MySQL

    Details

      Description

      I used AWS c5.2xlarge, 50Gb EBS ssd with 150 IOPs. The scripts to setup servers, sysbench, and run the benchmark are attached. (one only needs to edit my.cnf and start servers)

      Servers:

      • MariaDB 10.3 current, revision 2999492c3278528ceb9f37bd6cfca5ca5295ef9a
      • Percona Server 5.7 current, revision 6604e02a4ae73a8d542ba70e71ad91f2af4514cb
      • Facebook/MySQL-5.6 current, revision 5e398eab68dbf58312ab1544f0e42084552967e1

      Settings that were added to my.cnf:
      MariaDB:

      log_bin=1
      rocksdb_block_cache_size=2G
      binlog_format=row
      sync_binlog=1
      

      Percona Server:

      rocksdb_block_cache_size=2G
      log_bin=1
      

      Facebook/MySQL 5.6

      log-bin=pslp                                                                                                                                                    
      binlog-format=row                                                                                                                                               
      sync_binlog=1                                                                                                                                                   
      rocksdb_block_cache_size=2G                                                                                                                                     
      

      Sysbench prepare and run commands:

      sysbench /usr/share/sysbench/oltp_update_non_index.lua \
        --table-size=1000000 \
        --threads=$threads \
        --time=60 \
        --rand-type=uniform \
        --db-driver=mysql \
        --mysql-socket=/tmp/mysql20.sock \
        --mysql-user=root \
        --mysql_storage_engine=$engine \
        prepare
      

      sysbench /usr/share/sysbench/oltp_update_non_index.lua \
        --table-size=1000000 \
        --threads=$threads \
        --time=60 \
        --rand-type=uniform \
        --db-driver=mysql \
        --mysql-socket=/tmp/mysql20.sock \
        --mysql-user=root \
        --mysql_storage_engine=$engine \
        run 
      

      Results:

      Percona 5.7

      n_threads, qps
       20,  4117.79  
       50,  9487.79 
       80, 13952.85
      100, 16852.61
      150, 21942.59
      

      MariaDB 10.3

      n_threads, qps
       20,  3125.01
       50,  7494.81
       80, 11821.79
      100, 14749.30
      150, 20313.95
      

      FB/MySQL-5.6

      n_threads, qps
       20,  3291.02
       50,  7711.92
       80, 11394.20
      100, 13300.78
      150, 18795.42
      

        Attachments

        1. image-2018-12-26-12-14-32-900.png
          image-2018-12-26-12-14-32-900.png
          21 kB
        2. out-mariadb-10.3-rocksdb.log
          11 kB
        3. out-percona-5.7-rocksdb.log
          11 kB
        4. run-sysbench.sh
          2 kB
        5. screenshot-1.png
          screenshot-1.png
          19 kB
        6. screenshot-2.png
          screenshot-2.png
          17 kB
        7. screenshot-3.png
          screenshot-3.png
          35 kB
        8. setup-mariadb-current.sh
          1 kB
        9. setup-os-ubuntu.sh
          0.5 kB
        10. setup-percona-current.sh
          1 kB
        11. setup-sysbench-ubuntu.sh
          0.1 kB

          Issue Links

            Activity

              People

              • Assignee:
                psergey Sergei Petrunia
                Reporter:
                psergey Sergei Petrunia
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: