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

MariaRocks port: rocksdb.slow_query_log test (DISABLED)

    Details

      Description

      At the moment, rocksdb.slow_query_log fails with this error:

      2016-12-03 17:58:02 139837224450432 [ERROR] /home/psergey/dev-git/10.2
      mariarocks/sql/mysqld: unknown option '--log-slow-extra'
      

      The test itself checks that log-slow-extra produces a few RocksDB-related counters like so:

      # # Query_time: 0.022742  Lock_time: 0.000112 Rows_sent: 1  Rows_examined: 7500
       Thread_id: 2 Errno: 0 Killed: 0 Bytes_received: 0 Bytes_sent: 66 Read_first: 1 Read_last: 0
       Read_key: 0 Read_next: 7500 Read_prev: 0 Read_rnd: 0 Read_rnd_next: 0 *RocksDB_key_skipped: 9999 *
      *RocksDB_del_skipped: 2499 *
      Sort_merge_passes: 0 Sort_range_count: 0 Sort_rows: 0 Sort_scan_count: 0 Created_tmp_disk_tables: 0 Created_tmp_tables: 0 Tmp_table_bytes_written: 0 Start: 22:34:03 End: 22:34:03 Reads: 0 Read_time: 0.000000
      

      The patch that introduced this:
      https://github.com/facebook/mysql-5.6/commit/8098b78783624f87db83ed9c1022db3ba980f34e

      As one can see, the counters are collected/printed in engine-agnostic fashion (despite having names like RocksDB_del_skipped and not having any universal meaning).

      The question is, what do we do with this in MariaDB? Introduce a SE API "service" for printing extra stuff into the slow query log?

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated: