Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5422

MyRocks - Rocksdb_wal_size_limit_mb seems to have no impact

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: Not 5.6, 5.7.23-25, 8.0.13-4
    • Fix Version/s: None
    • Component/s: MyRocks
    • Environment:

      Description

      If you check the reference to the variable Rocksdb_wal_size_limit_mb at the following address...

      https://www.percona.com/doc/percona-server/5.7/myrocks/variables.html#rocksdb_wal_size_limit_mb

      You will see the definition as follows.

      Specifies the maximum size of all WAL files in megabytes before attempting to flush memtables and delete the oldest files

      Similarly, if you check the reference for variable rocksdb_max_total_wal_size at the following address...

      https://www.percona.com/doc/percona-server/5.7/myrocks/variables.html#rocksdb_max_total_wal_size

      You will see the definition as follows

      Specifies the maximum total size of WAL (write-ahead log) files, after which memtables are flushed

      Upon initial observation of the documentation you would be lead to believe that these two variables do the same thing. This seemed a little strange so I decided to do some testing.

      I started by setting rocksdb_max_total_wal_size to 16 Mb and rocksdb_wal_size_limit_mb to 32 Mb to see where the WAL file would be cut off for a memtable flush. As you'll see below by looking at WAL file 001700.log, it made it to 16 Mb before the WAL file was rotated. This is fine considering that if both variables do the same thing, we would see that cut off at 16 Mb. All is fine at this point.

      [root@centos7-1 .rocksdb]# cat /etc/my.cnf
      #
      # The Percona Server 5.7 configuration file.
      #
      #
      # * IMPORTANT: Additional settings that can override those from this file!
      #   The files must end with '.cnf', otherwise they'll be ignored.
      #   Please make any edits and changes to the appropriate sectional files
      #   included below.
      #[mysqld]
      #rocksdb_db_write_buffer_size = 10485760
      rocksdb_max_total_wal_size = 16777216
      rocksdb_wal_size_limit_mb = 32
      sql_mode = no_engine_substitution!includedir /etc/my.cnf.d/
      !includedir /etc/percona-server.conf.d/
      [root@centos7-1 .rocksdb]# systemctl restart mysqld
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql   74 Jan 14 14:06 001700.log
      [root@centos7-1 .rocksdb]# #started write
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql 565K Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql 2.1M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql 3.1M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql 4.7M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql 6.6M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql 8.2M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql 9.9M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql  14M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql  15M Jan 14 14:07 001700.log
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql  215 Jan 14 14:06 001692.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:06 001694.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:06 001699.sst
      -rw-r----- 1 mysql mysql 339K Jan 14 14:07 001713.log
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:07 001715.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      

      For my next test I swapped the two variables and set rocksdb_max_total_wal_size to 32 Mb and rocksdb_wal_size_limit_mb to 16 Mb. My assumption was that I was going to see a 16 Mb cut off again. However my test showed, as you can see below by look at file 001724.log, that the WAL file was cut off at 32 Mb

      [root@centos7-1 .rocksdb]# cat /etc/my.cnf
      #
      # The Percona Server 5.7 configuration file.
      #
      #
      # * IMPORTANT: Additional settings that can override those from this file!
      #   The files must end with '.cnf', otherwise they'll be ignored.
      #   Please make any edits and changes to the appropriate sectional files
      #   included below.
      #[mysqld]
      #rocksdb_db_write_buffer_size = 10485760
      rocksdb_max_total_wal_size = 33554432
      rocksdb_wal_size_limit_mb = 16
      sql_mode = no_engine_substitution!includedir /etc/my.cnf.d/
      !includedir /etc/percona-server.conf.d/
      [root@centos7-1 .rocksdb]# systemctl restart mysqld
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      -rw-r----- 1 mysql mysql  117 Jan 14 14:08 001718.log
      -rw-r----- 1 mysql mysql 5.8M Jan 14 14:08 001720.sst
      -rw-r----- 1 mysql mysql   74 Jan 14 14:08 001724.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:08 001730.sst
      [root@centos7-1 .rocksdb]# #started write
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      -rw-r----- 1 mysql mysql  117 Jan 14 14:08 001718.log
      -rw-r----- 1 mysql mysql 5.8M Jan 14 14:08 001720.sst
      -rw-r----- 1 mysql mysql 339K Jan 14 14:09 001724.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:08 001730.sst
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      -rw-r----- 1 mysql mysql  117 Jan 14 14:08 001718.log
      -rw-r----- 1 mysql mysql 5.8M Jan 14 14:08 001720.sst
      -rw-r----- 1 mysql mysql 1.4M Jan 14 14:09 001724.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:08 001730.sst
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      -rw-r----- 1 mysql mysql  117 Jan 14 14:08 001718.log
      -rw-r----- 1 mysql mysql 5.8M Jan 14 14:08 001720.sst
      -rw-r----- 1 mysql mysql 2.7M Jan 14 14:09 001724.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:08 001730.sst
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      -rw-r----- 1 mysql mysql  117 Jan 14 14:08 001718.log
      -rw-r----- 1 mysql mysql 5.8M Jan 14 14:08 001720.sst
      -rw-r----- 1 mysql mysql 4.2M Jan 14 14:09 001724.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:08 001730.sst
      ......
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      -rw-r----- 1 mysql mysql  117 Jan 14 14:08 001718.log
      -rw-r----- 1 mysql mysql 5.8M Jan 14 14:08 001720.sst
      -rw-r----- 1 mysql mysql  31M Jan 14 14:10 001724.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:08 001730.sst
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      -rw-r----- 1 mysql mysql  117 Jan 14 14:08 001718.log
      -rw-r----- 1 mysql mysql 5.8M Jan 14 14:08 001720.sst
      -rw-r----- 1 mysql mysql  32M Jan 14 14:10 001724.log
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:08 001730.sst
      [root@centos7-1 .rocksdb]# ls -lh | grep -e ".log" -e ".sst"
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001667.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001668.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:04 001670.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:06 001690.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:06 001691.sst
      -rw-r----- 1 mysql mysql 6.0M Jan 14 14:06 001695.sst
      -rw-r----- 1 mysql mysql 229K Jan 14 14:06 001696.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:07 001716.sst
      -rw-r----- 1 mysql mysql 5.2M Jan 14 14:07 001717.sst
      -rw-r----- 1 mysql mysql  117 Jan 14 14:08 001718.log
      -rw-r----- 1 mysql mysql 5.8M Jan 14 14:08 001720.sst
      -rw-r----- 1 mysql mysql 1.7K Jan 14 14:08 001730.sst
      -rw-r----- 1 mysql mysql 792K Jan 14 14:10 001738.log
      -rw-r----- 1 mysql mysql 1.2K Jan 14 14:10 001740.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:10 001741.sst
      -rw-r----- 1 mysql mysql  12M Jan 14 14:10 001742.sst
      -rw-r----- 1 mysql mysql  11M Jan 14 14:10 001743.sst
      

      In conclusion I believe that, based on the documented definition, the Rocksdb_wal_size_limit_mb variable is potentially deprecated and isn't being used by MyRocks. Either that or the documentation is incorrect.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                Sylvester Peter Sylvester
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: