maria:bb-10.9-MDEV-27021-MDEV-10000-show-analyze

Branch merges

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related charm recipes

cbe6bf0... by Oleg Smirnov on 2022-03-07

MDEV-27776 Make EXPLAIN show filtered and partitions columns

cc5d67c... by Oleg Smirnov on 2022-02-16

MDEV-27021 Add explicit indication of SHOW EXPLAIN/ANALYZE.

1. Add explicit indication that the output is produced by
SHOW EXPLAIN/ANALYZE FORMAT=JSON command.
2. Remove useless "r_total_time_ms" field from SHOW ANALYZE FORMAT=JSON
output when there is no timed statistics gathered.
3. Add "r_query_time_in_progress_ms" to the output of SHOW ANALYZE FORMAT=JSON.

83d16e4... by Oleg Smirnov on 2022-02-02

MDEV-27021 Add support of FORMAT=JSON for SHOW ANALYZE

c52f04a... by Oleg Smirnov <email address hidden> on 2021-12-24

MDEV-27021 Implement SHOW ANALYZE command

6e32feb... by Oleg Smirnov on 2022-01-11

MDEV-10000 Add EXPLAIN [FORMAT=JSON] FOR CONNECTION syntax support

EXPLAIN FOR CONNECTION is a MySQL-compatible syntax for SHOW EXPLAIN.
This commit also adds support for FORMAT=JSON to SHOW EXPLAIN,
so the possible options to get JSON-formatted output are:
- SHOW EXPLAIN FORMAT=JSON FOR $con
- EXPLAIN FORMAT=JSON FOR CONNECTION $con

a9e00a0... by Marko Mäkelä on 2022-02-15

Merge 10.8 into 10.9

8251a9f... by Marko Mäkelä on 2022-02-15

MDEV-27848 fixup: Use os_file_close_func()

To close a non-instrumented file, os_file_close_func() should be used
instead of os_file_close().

f1beeb5... by Marko Mäkelä on 2022-02-15

MDEV-27848: Remove unused wait/io/file/innodb/innodb_log_file

The performance_schema counter wait/io/file/innodb/innodb_log_file
is always reported as 0.

The way how redo log writes are being waited for was refactored in
commit 30ea63b7d2077883713e63cbf4e661ba0345bf68 by the introduction
of flush_lock and write_lock. Even before that change, all the
wait/io/file/innodb/ counters were always 0 in my tests.

Moreover, if the PMEM interface that was introduced in
commit 3daef523af25e4f1e4e75d2c26a9b25475f0c679
is being used, writes to the InnoDB log file will completely avoid
any system calls and performance_schema instrumentation.
In commit 685d958e38b825ad9829be311f26729cccf37c46 also the reads
of the redo log (during recovery) would bypass any system calls.

f8b3c66... by Marko Mäkelä on 2022-02-14

Merge 10.8 into 10.9

3b06415... by Marko Mäkelä on 2022-02-14

Clean up log resizing

log_t::rename_resized(): Replaces create_log_file_rename()

delete_log_files(): Moved to a separate function. Also invoked
on a normal startup when the log is not being resized, to
remove any garbage log files.

create_log_file(): Remove the std::string& parameter.

os_file_delete_if_exists_func() [_WIN32]: Do not retry DeleteFile()
on ERROR_ACCESS_DENIED.