MariaDB

maria:bb-10.6.9-hash-join-improvements

  1. Git
  2. lp:maria
  3. bb-10.6.9-hash-join-improvements
Last commit made on 2023-03-13
Get this branch:
git clone -b bb-10.6.9-hash-join-improvements https://git.launchpad.net/maria

Branch merges

Branch information

Name:
bb-10.6.9-hash-join-improvements
Repository:
lp:maria

Recent commits

46b0131... by Monty <email address hidden>

fixup! 2cc16653817dd80df1c57f7d8499352fc1eeaa5b

43c8f31... by Sergey Petrunia

ANALYZE FORMAT=JSON: Backport block-nl-join.r_unpack_time_ms from 11.0

Also fix it to work with hashed join.

2cc1665... by Sergey Petrunia

MDEV-30812: Improve output cardinality estimates for hash join

Introduce @@optimizer_switch flag: hash_join_cardinality

When it is on, use EITS statistics to produce tighter bounds for
hash join output cardinality.

Reviewed by: Monty <email address hidden>

cc34811... by Sergey Petrunia

MDEV-30806: ANALYZE FORMAT=JSON: better support for BNL and BNL-H joins

In block-nl-join, add:

- r_loops - this shows how many incoming record combinations this
  query plan node had.

- r_effective_rows - this shows the average number of matching rows
  that this table had for each incoming record combination. This is
  comparable with r_rows in non-BNL(H) access methods.
  For BNL-joins, it is always equal to
   $.table.r_rows * $.table.r_filtered
  For BNL-H joins the value cannot be computed from other values

Reviewed by: Monty <email address hidden>

b8f6d31... by Addison G <email address hidden>

MDEV-29222 - Fix mysqld_safe script

The mysqld_safe script was using bad grep options.

The line that was fixed was likely meant to be 2 separate grep commands,
piped into each other, with each one removing any lines that matched.

The `-E` option was unneeded, as the command is not using regex.

c442e1a... by Oleksandr "Sanja" Byelkin

Merge branch '10.5' into 10.6

1ac0bce... by Oleksandr "Sanja" Byelkin

Merge branch '10.4' into 10.5

65e8506... by Oleksandr "Sanja" Byelkin

Merge branch '10.3' into bb-10.4-release

faddcf3... by Nayuta Yanagisawa

Do not check symbol returned (or not and so there is some garbadge) by mb_wc() if mb_wc() failed

1227428... by Sergei Golubchik

my_safe_process: try to kill the process softly first

first SIGTERM and if the process didn't die in 10 seconds, SIGKILL it.

This allows various tools like `rr`, `gcov`, `gprof`, etc to flush
their data to disk properly