[MDEV-11480] MariaRocks port: rocksdb.slow_query_log test (DISABLED) Created: 2016-12-03  Updated: 2018-04-19

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: N/A
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-9658 Make MyRocks in MariaDB stable Closed

 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?


Generated at Thu Feb 08 07:50:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.