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

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

    XMLWordPrintable

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

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.