[MDEV-15342] log_slow_verbosity='innodb' Created: 2018-02-17  Updated: 2018-04-30  Resolved: 2018-04-30

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Storage Engine - InnoDB
Affects Version/s: 10.1.31
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Kamil Dziedzic Assignee: Ian Gilfillan
Resolution: Not a Bug Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-15343 log_slow_verbosity='innodb' Closed

 Description   

Hi, documentation for log_slow_verbosity https://mariadb.com/kb/en/library/server-system-variables/#log_slow_verbosity mentions "innodb" as one of possible values, however I don't see any new values in the slowlog file. log_slow_verbosity='explain' works fine, but log_slow_verbosity='innodb' doesn't seem to make any difference.

# User@Host: sbtest[sbtest] @ localhost []
# Thread_id: 1529055  Schema: onlineddl  QC_hit: No
# Query_time: 0.007609  Lock_time: 0.000062  Rows_sent: 0  Rows_examined: 1
# Rows_affected: 1
SET timestamp=1518806988;
DELETE FROM sbtest1 WHERE id=100798;



 Comments   
Comment by Elena Stepanova [ 2018-02-17 ]

Thanks for the report.

It looks like the feature either has never been fully merged from Percona's XtraDB to MariaDB, or was lost long time ago. There are pieces of it in XtraDB code, but they are under #ifdef EXTENDED_SLOWLOG, and I don't see it defined anywhere.

Given that MariaDB 10.2+ does not provide XtraDB anymore, it's pointless to fix it in XtraDB; and it looks like InnoDB never had it at all.

jplindst, could you please confirm and pass it over to documentation? (And, if you decide that it needs to be implemented in InnoDB, create a task for it or convert this report into one).

Comment by Kamil Dziedzic [ 2018-02-18 ]

Sorry for the other dupe issue and thanks for explanation. Update in documentation would be nice, thanks!

Comment by Jan Lindström (Inactive) [ 2018-04-30 ]

greenman Can you update the documentation.

Generated at Thu Feb 08 08:20:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.