Details

Type: New Feature
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Fix Version/s: None
Component/s: None
Labels:
- Preview_11.5
- beginner-friendly

Description

There are many mariadbd command-line options and system variables which have aliases or alternate names:

In some cases (e.g. --old-alter-table vs. --alter-algorithm), some of the names are deprecated.

In other cases (e.g. --tmp-memory-table-size vs. --tmp-table-size), there's no clear distinction in terms of deprecation/preference.

In all cases, the options/variable are listed multiple times in the mariadb --verbose --help output, with:

Almost entirely redundant content.
No consistent way in which the aliases or other names are presented.

In order to simplify the documentation, it would be beneficial to combine the listing of these options in the verbose help text.

Examples of how options with multiple names are shown now

$ mariadbd --verbose --help

...

  --alter-algorithm[=name]

                      Specify the alter table algorithm. One of: DEFAULT, COPY,

                      INPLACE, NOCOPY, INSTANT

…

  --old-alter-table[=name]

                      Alias for alter_algorithm. Deprecated. Use

                      --alter-algorithm instead.. One of: DEFAULT, COPY,

                      INPLACE, NOCOPY, INSTANT

...

  --tmp-memory-table-size=#

                      If an internal in-memory temporary table exceeds this

                      size, MariaDB will automatically convert it to an on-disk

                      MyISAM or Aria table. Same as tmp_table_size.

  --tmp-table-size=#  Alias for tmp_memory_table_size. If an internal in-memory

                      temporary table exceeds this size, MariaDB will

                      automatically convert it to an on-disk MyISAM or Aria

                      table.

How these should be shown

This format will considerably shorten the verbose help output, enable users to quickly recognize aliases, and identify which of those aliases are deprecated.

$ mariadbd --verbose --help

...

  --alter-algorithm[=name]

  --old-alter-table[=name]    (Deprecated)

                      Specify the alter table algorithm. One of: DEFAULT, COPY,

                      INPLACE, NOCOPY, INSTANT

…

  --tmp-memory-table-size=#

  --tmp-table-size=#

                      If an internal in-memory temporary table exceeds this

                      size, MariaDB will automatically convert it to an on-disk

                      MyISAM or Aria table.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

a.patch
37 kB
2024-05-14 16:31

Issue Links

blocks

MDEV-29297 remove aliases of system variables

Open

MDEV-30731 Deprecated variables are not consistently highlighted

Open

includes

MDEV-25275 Remove temp-pool option and/or deprecate it properly

Closed

MDEV-30332 PLUGIN_VAR_DEPRECATED fails to throw a warning on startup

Closed

relates to

MDEV-33503 innodb_log_files_in_group is quietly ignored

Confirmed

Activity

Ascending order - Click to sort in descending order

Daniel Lenski (Inactive) created issue - 2022-05-25 22:42

Daniel Lenski (Inactive) made changes - 2022-05-25 22:43

Field	Original Value	New Value
Description	There are many {{mariadbd}} command-line options and system variables which have aliases or alternate names: In some cases (e.g. {{--old-alter-table}} vs. {{--alter-algorithm}}), some of the names are deprecated. In other cases (e.g. {{--tmp-memory-table-size}} vs. {{--tmp-table-size}}), there's no clear distinction in terms of deprecation/preference. In all cases, the options/variable are listed multiple times in the {{mariadb --verbose --help}} output, with: * Almost entirely redundant content. * No consistent way in which the aliases or other names are presented. In order to simplify the documentation, it would be beneficial to combine the listing of these options in the verbose help text. h1. Examples of how aliases are shown now {noformat} --alter-algorithm[=name] Specify the alter table algorithm. One of: DEFAULT, COPY, INPLACE, NOCOPY, INSTANT … --old-alter-table[=name] Alias for alter_algorithm. Deprecated. Use --alter-algorithm instead.. One of: DEFAULT, COPY, INPLACE, NOCOPY, INSTANT ... --tmp-memory-table-size=# If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. Same as tmp_table_size. --tmp-table-size=# Alias for tmp_memory_table_size. If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. {noformat} # How these _should_ be shown This form will make the verbose help output considerably shorter, make it easy for users to recognize aliases, and identify which of those aliases are deprecated. ``` --alter-algorithm[=name] --old-alter-table[=name] (Deprecated) Specify the alter table algorithm. One of: DEFAULT, COPY, INPLACE, NOCOPY, INSTANT … --tmp-memory-table-size=# --tmp-table-size=# If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. ```	There are many {{mariadbd}} command-line options and system variables which have aliases or alternate names: In some cases (e.g. {{\-\-old-alter-table}} vs. {{\-\-alter-algorithm}}), some of the names are deprecated. In other cases (e.g. {{\-\-tmp-memory-table-size}} vs. {{\-\-tmp-table-size}}), there's no clear distinction in terms of deprecation/preference. In all cases, the options/variable are listed multiple times in the {{mariadb --verbose --help}} output, with: * Almost entirely redundant content. * No consistent way in which the aliases or other names are presented. In order to simplify the documentation, it would be beneficial to combine the listing of these options in the verbose help text. h1. Examples of how options with multiple names are shown now {noformat} $ mariadbd --verbose --help ... --alter-algorithm[=name] Specify the alter table algorithm. One of: DEFAULT, COPY, INPLACE, NOCOPY, INSTANT … --old-alter-table[=name] Alias for alter_algorithm. Deprecated. Use --alter-algorithm instead.. One of: DEFAULT, COPY, INPLACE, NOCOPY, INSTANT ... --tmp-memory-table-size=# If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. Same as tmp_table_size. --tmp-table-size=# Alias for tmp_memory_table_size. If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. {noformat} # How these _should_ be shown This form will make the verbose help output considerably shorter, make it easy for users to recognize aliases, and identify which of those aliases are deprecated. ``` $ mariadbd --verbose --help ... --alter-algorithm[=name] --old-alter-table[=name] (Deprecated) Specify the alter table algorithm. One of: DEFAULT, COPY, INPLACE, NOCOPY, INSTANT … --tmp-memory-table-size=# --tmp-table-size=# If an internal in-memory temporary table exceeds this size, MariaDB will automatically convert it to an on-disk MyISAM or Aria table. ```

Daniel Lenski (Inactive) made changes - 2022-05-25 22:43

Description

There are many {{mariadbd}} command-line options and system variables which have aliases or alternate names:

In some cases (e.g. {{\-\-old-alter-table}} vs. {{\-\-alter-algorithm}}), some of the names are deprecated.

In other cases (e.g. {{\-\-tmp-memory-table-size}} vs. {{\-\-tmp-table-size}}), there's no clear distinction in terms of deprecation/preference.

In all cases, the options/variable are listed *multiple times* in the {{mariadb --verbose --help}} output, with:
* Almost entirely redundant content.
* No consistent way in which the aliases or other names are presented.

In order to simplify the documentation, it would be beneficial to combine the listing of these options in the verbose help text.

h1. Examples of how options with multiple names are shown now

{noformat}
$ mariadbd --verbose --help
  ...
  --alter-algorithm[=name]
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  …
  --old-alter-table[=name]
                      Alias for alter_algorithm. Deprecated. Use
                      --alter-algorithm instead.. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  ...
  --tmp-memory-table-size=#
                      If an internal in-memory temporary table exceeds this
                      size, MariaDB will automatically convert it to an on-disk
                      MyISAM or Aria table. Same as tmp_table_size.
  --tmp-table-size=# Alias for tmp_memory_table_size. If an internal in-memory
                      temporary table exceeds this size, MariaDB will
                      automatically convert it to an on-disk MyISAM or Aria
                      table.
{noformat}

# How these _should_ be shown

This form will make the verbose help output considerably shorter, make it easy for users to recognize aliases, and identify which of those aliases are deprecated.

```
$ mariadbd --verbose --help
  ...
  --alter-algorithm[=name]
  --old-alter-table[=name] (Deprecated)
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  …
  --tmp-memory-table-size=#
  --tmp-table-size=#
                      If an internal in-memory temporary table exceeds this
                      size, MariaDB will automatically convert it to an on-disk
                      MyISAM or Aria table.
```

There are many {{mariadbd}} command-line options and system variables which have aliases or alternate names:

In some cases (e.g. {{\-\-old-alter-table}} vs. {{\-\-alter-algorithm}}), some of the names are deprecated.

In other cases (e.g. {{\-\-tmp-memory-table-size}} vs. {{\-\-tmp-table-size}}), there's no clear distinction in terms of deprecation/preference.

In all cases, the options/variable are listed *multiple times* in the {{mariadb --verbose --help}} output, with:
* Almost entirely redundant content.
* No consistent way in which the aliases or other names are presented.

In order to simplify the documentation, it would be beneficial to combine the listing of these options in the verbose help text.

h1. Examples of how options with multiple names are shown now

{noformat}
$ mariadbd --verbose --help
  ...
  --alter-algorithm[=name]
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  …
  --old-alter-table[=name]
                      Alias for alter_algorithm. Deprecated. Use
                      --alter-algorithm instead.. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  ...
  --tmp-memory-table-size=#
                      If an internal in-memory temporary table exceeds this
                      size, MariaDB will automatically convert it to an on-disk
                      MyISAM or Aria table. Same as tmp_table_size.
  --tmp-table-size=# Alias for tmp_memory_table_size. If an internal in-memory
                      temporary table exceeds this size, MariaDB will
                      automatically convert it to an on-disk MyISAM or Aria
                      table.
{noformat}

h1. How these _should_ be shown

This format will considerably shorten the verbose help output, enable users to quickly recognize aliases, and identify which of those aliases are deprecated.

```
$ mariadbd --verbose --help
  ...
  --alter-algorithm[=name]
  --old-alter-table[=name] (Deprecated)
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  …
  --tmp-memory-table-size=#
  --tmp-table-size=#
                      If an internal in-memory temporary table exceeds this
                      size, MariaDB will automatically convert it to an on-disk
                      MyISAM or Aria table.
```

Daniel Lenski (Inactive) made changes - 2022-05-25 22:44

Description

There are many {{mariadbd}} command-line options and system variables which have aliases or alternate names:

In some cases (e.g. {{\-\-old-alter-table}} vs. {{\-\-alter-algorithm}}), some of the names are deprecated.

In other cases (e.g. {{\-\-tmp-memory-table-size}} vs. {{\-\-tmp-table-size}}), there's no clear distinction in terms of deprecation/preference.

In all cases, the options/variable are listed *multiple times* in the {{mariadb --verbose --help}} output, with:
* Almost entirely redundant content.
* No consistent way in which the aliases or other names are presented.

In order to simplify the documentation, it would be beneficial to combine the listing of these options in the verbose help text.

h1. Examples of how options with multiple names are shown now

{noformat}
$ mariadbd --verbose --help
  ...
  --alter-algorithm[=name]
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  …
  --old-alter-table[=name]
                      Alias for alter_algorithm. Deprecated. Use
                      --alter-algorithm instead.. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  ...
  --tmp-memory-table-size=#
                      If an internal in-memory temporary table exceeds this
                      size, MariaDB will automatically convert it to an on-disk
                      MyISAM or Aria table. Same as tmp_table_size.
  --tmp-table-size=# Alias for tmp_memory_table_size. If an internal in-memory
                      temporary table exceeds this size, MariaDB will
                      automatically convert it to an on-disk MyISAM or Aria
                      table.
{noformat}

h1. How these _should_ be shown

This format will considerably shorten the verbose help output, enable users to quickly recognize aliases, and identify which of those aliases are deprecated.

```
$ mariadbd --verbose --help
  ...
  --alter-algorithm[=name]
  --old-alter-table[=name] (Deprecated)
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  …
  --tmp-memory-table-size=#
  --tmp-table-size=#
                      If an internal in-memory temporary table exceeds this
                      size, MariaDB will automatically convert it to an on-disk
                      MyISAM or Aria table.
```

There are many {{mariadbd}} command-line options and system variables which have aliases or alternate names:

In some cases (e.g. {{\-\-old-alter-table}} vs. {{\-\-alter-algorithm}}), some of the names are deprecated.

In other cases (e.g. {{\-\-tmp-memory-table-size}} vs. {{\-\-tmp-table-size}}), there's no clear distinction in terms of deprecation/preference.

In all cases, the options/variable are listed *multiple times* in the {{mariadb --verbose --help}} output, with:
* Almost entirely redundant content.
* No consistent way in which the aliases or other names are presented.

In order to simplify the documentation, it would be beneficial to combine the listing of these options in the verbose help text.

h1. Examples of how options with multiple names are shown now

{noformat}
$ mariadbd --verbose --help
  ...
  --alter-algorithm[=name]
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  …
  --old-alter-table[=name]
                      Alias for alter_algorithm. Deprecated. Use
                      --alter-algorithm instead.. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  ...
  --tmp-memory-table-size=#
                      If an internal in-memory temporary table exceeds this
                      size, MariaDB will automatically convert it to an on-disk
                      MyISAM or Aria table. Same as tmp_table_size.
  --tmp-table-size=# Alias for tmp_memory_table_size. If an internal in-memory
                      temporary table exceeds this size, MariaDB will
                      automatically convert it to an on-disk MyISAM or Aria
                      table.
{noformat}

h1. How these _should_ be shown

This format will considerably shorten the verbose help output, enable users to quickly recognize aliases, and identify which of those aliases are deprecated.

{noformat}
$ mariadbd --verbose --help
  ...
  --alter-algorithm[=name]
  --old-alter-table[=name] (Deprecated)
                      Specify the alter table algorithm. One of: DEFAULT, COPY,
                      INPLACE, NOCOPY, INSTANT
  …
  --tmp-memory-table-size=#
  --tmp-table-size=#
                      If an internal in-memory temporary table exceeds this
                      size, MariaDB will automatically convert it to an on-disk
                      MyISAM or Aria table.
{noformat}

Daniel Black added a comment - 2022-05-25 22:48

Good call in removing deprecated options here.

Be a bit careful however, the --help --verbose text is used by machine parsing in some circumstances.

Daniel Black added a comment - 2022-05-25 22:48 Good call in removing deprecated options here. Be a bit careful however, the --help --verbose text is used by machine parsing in some circumstances .

Daniel Lenski (Inactive) added a comment - 2022-05-25 23:28

Thanks! To be clear, I wasn't proposing to remove them entirely from the listing, but simply to list them as deprecated; although if you're okay with simply removing the ones that are deprecated, I'd be in favor of that too.

Be a bit careful however, the --help --verbose text is used by machine parsing in some circumstances.

From the comment preceding that line, it looks like the verbose help text is only parsed because my_print_defaults is missing some of the relevant information. (https://github.com/MariaDB/mariadb-docker/blob/master/docker-entrypoint.sh#L111-L119)

Perhaps we could improve the my_print_defaults output and de-cruft the options list in one fell swoop.

Daniel Lenski (Inactive) added a comment - 2022-05-25 23:28 Thanks! To be clear, I wasn't proposing to remove them entirely from the listing, but simply to list them as deprecated; although if you're okay with simply removing the ones that are deprecated, I'd be in favor of that too. Be a bit careful however, the --help --verbose text is used by machine parsing in some circumstances . From the comment preceding that line, it looks like the verbose help text is only parsed because my_print_defaults is missing some of the relevant information. ( https://github.com/MariaDB/mariadb-docker/blob/master/docker-entrypoint.sh#L111-L119 ) Perhaps we could improve the my_print_defaults output and de-cruft the options list in one fell swoop.

Daniel Black added a comment - 2022-05-26 00:48

I'm in favour of removal from output. serg do you have a preference?

The problem with my_print_defaults is that it can parse config files and arguments well, however what scripts are often after is the server defaults (which also neglects the auto sized/determined values which are not in the output of --help --verbose as far as I remember). Its a rather big task if you want to take it on (I suspect it would be taking sys_vars.cc and compiling into both the my_print_defaults and server).

Daniel Black added a comment - 2022-05-26 00:48 I'm in favour of removal from output. serg do you have a preference? The problem with my_print_defaults is that it can parse config files and arguments well, however what scripts are often after is the server defaults (which also neglects the auto sized/determined values which are not in the output of --help --verbose as far as I remember). Its a rather big task if you want to take it on (I suspect it would be taking sys_vars.cc and compiling into both the my_print_defaults and server).

Sergei Golubchik added a comment - 2022-06-06 19:55

Yes, let's remove deprecated options and aliases

Sergei Golubchik added a comment - 2022-06-06 19:55 Yes, let's remove deprecated options and aliases

Sergei Golubchik made changes - 2022-06-13 19:38

Labels

beginner-friendly

kurt.ding made changes - 2022-09-21 07:32

Comment

[ I look at the output and I found it orderd by alphabetical for cmd options and variables .
So I think maybe this is ok for searching , if we make two aliases closer , the code maybe is a llittle hard to maintain. ]

Christian Gonzalez added a comment - 2022-11-24 19:17

Hi! I can start working on this one if nobody else is doing it.

Christian Gonzalez added a comment - 2022-11-24 19:17 Hi! I can start working on this one if nobody else is doing it.

Daniel Black added a comment - 2022-11-24 22:40

Christianggm, nobody is immediately working on it so please go for it. Looking forward to seeing your code.

Daniel Black added a comment - 2022-11-24 22:40 Christianggm , nobody is immediately working on it so please go for it. Looking forward to seeing your code.

Daniel Black made changes - 2023-01-03 01:25

Assignee

Daniel Black [ danblack ]

Daniel Black made changes - 2023-01-03 01:25

Fix Version/s

11.0 [ 28320 ]

Daniel Black made changes - 2023-01-03 01:25

Status

Open [ 1 ]

In Progress [ 3 ]

Daniel Black added a comment - 2023-01-03 01:26

Happy with https://github.com/MariaDB/server/pull/2376 ?

Daniel Black added a comment - 2023-01-03 01:26 Happy with https://github.com/MariaDB/server/pull/2376 ?

Daniel Black made changes - 2023-01-03 01:26

Assignee	Daniel Black [ danblack ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2023-01-04 11:58

Fix Version/s		11.1 [ 28549 ]
Fix Version/s	11.0 [ 28320 ]

Sergei Golubchik made changes - 2023-01-04 12:20

Link

This issue includes ~~MDEV-30332~~ [ ~~MDEV-30332~~ ]

Sergei Golubchik made changes - 2023-01-04 12:21

Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s	11.1 [ 28549 ]

Sergei Golubchik made changes - 2023-01-31 19:18

Link

This issue blocks MDEV-29297 [ MDEV-29297 ]

Marko Mäkelä made changes - 2023-02-27 06:32

Link

This issue relates to MDEV-30731 [ MDEV-30731 ]

Julien Fritsch made changes - 2023-03-03 17:24

Fix Version/s

10.7 [ 24805 ]

Sergei Golubchik made changes - 2023-03-10 16:18

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Sergei Golubchik made changes - 2023-03-26 19:40

Link

This issue blocks MDEV-30731 [ MDEV-30731 ]

Sergei Golubchik made changes - 2023-03-26 19:40

Link

This issue relates to MDEV-30731 [ MDEV-30731 ]

Julien Fritsch made changes - 2023-04-27 14:57

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-11-28 10:23

Fix Version/s

10.9 [ 26905 ]

Julien Fritsch made changes - 2023-11-28 10:28

Fix Version/s

10.10 [ 27530 ]

Sergei Golubchik made changes - 2024-01-23 10:08

Fix Version/s

11.5 [ 29506 ]

Sergei Golubchik made changes - 2024-01-23 10:08

Priority

Major [ 3 ]

Critical [ 2 ]

Marko Mäkelä made changes - 2024-02-21 06:51

Link

This issue relates to MDEV-33503 [ MDEV-33503 ]

Sergei Golubchik made changes - 2024-02-27 11:29

Fix Version/s

10.11 [ 27614 ]

Sergei Golubchik made changes - 2024-03-12 15:40

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Sergei Golubchik added a comment - 2024-03-12 16:55

git diff 1e889a6e6c5 c1e6afe3bac

Sergei Golubchik added a comment - 2024-03-12 16:55 git diff 1e889a6e6c5 c1e6afe3bac

Sergei Golubchik made changes - 2024-03-12 16:55

Assignee	Sergei Golubchik [ serg ]	Oleksandr Byelkin [ sanja ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Oleksandr Byelkin added a comment - 2024-03-14 09:03

OK to push

Oleksandr Byelkin added a comment - 2024-03-14 09:03 OK to push

Oleksandr Byelkin made changes - 2024-03-14 09:03

Assignee	Oleksandr Byelkin [ sanja ]	Sergei Golubchik [ serg ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2024-03-14 20:04

Status

Stalled [ 10000 ]

In Testing [ 10301 ]

Sergei Golubchik made changes - 2024-03-14 20:05

Assignee

Sergei Golubchik [ serg ]

Elena Stepanova [ elenst ]

Elena Stepanova made changes - 2024-03-14 20:14

Assignee

Elena Stepanova [ elenst ]

Alice Sherepa [ alice ]

Sergei Golubchik added a comment - 2024-03-14 20:16

What was actually implemented evolved quite a bit from the original task, it doesn't clearly show aliases and does not remove the verbosity, so we shouldn't close this MDEV when https://github.com/MariaDB/server/pull/2376 gets pushed.

Still, the PR it adds useful functionality, that is: Deprecation message is printed not only for SET but also for command line options, and the --help text includes a deprecation warning for deprecated command line options

Sergei Golubchik added a comment - 2024-03-14 20:16 What was actually implemented evolved quite a bit from the original task, it doesn't clearly show aliases and does not remove the verbosity, so we shouldn't close this MDEV when https://github.com/MariaDB/server/pull/2376 gets pushed. Still, the PR it adds useful functionality, that is: Deprecation message is printed not only for SET but also for command line options, and the --help text includes a deprecation warning for deprecated command line options

Sergei Golubchik made changes - 2024-03-17 18:32

Link

This issue is part of TODO-4630 [ TODO-4630 ]

Sergei Golubchik made changes - 2024-03-17 18:35

Issue Type

Task [ 3 ]

New Feature [ 2 ]

Sergei Golubchik added a comment - 2024-03-17 20:05

https://github.com/MariaDB/server/tree/bb-11.5-MDEV-28671-deprecated-in-cmdline

Sergei Golubchik added a comment - 2024-03-17 20:05 https://github.com/MariaDB/server/tree/bb-11.5-MDEV-28671-deprecated-in-cmdline

Ralf Gebhardt made changes - 2024-03-20 15:12

Labels

beginner-friendly

Preview_11.5 beginner-friendly

Alice Sherepa added a comment - 2024-04-26 13:02 - edited

Please rephrase it here:

"--innodb-prefix-index-cluster-optimization

                      Deprecated parameter with no effect. Deprecated, will be

                      removed in a future release.

                      (Defaults to on; use --skip-innodb-prefix-index-cluster-optimization to disable.)

--innodb-purge-rseg-truncate-frequency[=#]

                      Deprecated parameter with no effect. Deprecated, will be

                      removed in a future release."

Please add "will be removed in a future release" here:

"  --temp-pool         Using this option will cause most temporary files created

                      to use a small set of names, rather than a unique name

                      for each new file. Deprecated"

+ temp-pool does not give a warning about deprecation after startup

Could you please also check the status of :

  --metadata-locks-cache-size=#

                      Unused

  --metadata-locks-hash-instances=#

                      Unused

while KB says nothing about the 'unused':

metadata_locks_cache_size

Description: Size of the metadata locks cache, used for reducing the need to create and destroy synchronization objects. It is particularly helpful on systems where this process is inefficient, such as Windows XP.

Commandline: --metadata-locks-cache-size=#

Scope: Global

Dynamic: No

Data Type: numeric

Default Value: 1024

Range: 1 to 1048576

metadata_locks_hash_instances

Description: Number of hashes used by the set of metadata locks. The metadata locks are partitioned into separate hashes in order to reduce contention.

Commandline: --metadata-locks-hash-instances=#

Scope: Global

Dynamic: No

Data Type: numeric

Default Value: 8

Range: 1 to 1024

Alice Sherepa added a comment - 2024-04-26 13:02 - edited Please rephrase it here: "--innodb-prefix-index-cluster-optimization Deprecated parameter with no effect. Deprecated, will be removed in a future release. (Defaults to on; use --skip-innodb-prefix-index-cluster-optimization to disable.) --innodb-purge-rseg-truncate-frequency[=#] Deprecated parameter with no effect. Deprecated, will be removed in a future release." Please add "will be removed in a future release" here: " --temp-pool Using this option will cause most temporary files created to use a small set of names, rather than a unique name for each new file. Deprecated" + temp-pool does not give a warning about deprecation after startup Could you please also check the status of : --metadata-locks-cache-size=# Unused --metadata-locks-hash-instances=# Unused while KB says nothing about the 'unused': metadata_locks_cache_size Description: Size of the metadata locks cache, used for reducing the need to create and destroy synchronization objects. It is particularly helpful on systems where this process is inefficient, such as Windows XP. Commandline: --metadata-locks-cache-size=# Scope: Global Dynamic: No Data Type: numeric Default Value: 1024 Range: 1 to 1048576 metadata_locks_hash_instances Description: Number of hashes used by the set of metadata locks. The metadata locks are partitioned into separate hashes in order to reduce contention. Commandline: --metadata-locks-hash-instances=# Scope: Global Dynamic: No Data Type: numeric Default Value: 8 Range: 1 to 1024

Alice Sherepa made changes - 2024-05-14 16:31

Attachment

a.patch [ 73490 ]

Alice Sherepa added a comment - 2024-05-15 13:47

3c4ed5aa3da635d3f46d5612a3523236260fcd18 commit is ok to push

Alice Sherepa added a comment - 2024-05-15 13:47 3c4ed5aa3da635d3f46d5612a3523236260fcd18 commit is ok to push

Alice Sherepa made changes - 2024-05-15 13:47

Assignee

Alice Sherepa [ alice ]

Sergei Golubchik [ serg ]

Alice Sherepa made changes - 2024-05-15 13:48

Status

In Testing [ 10301 ]

Stalled [ 10000 ]

Sergei Golubchik added a comment - 2024-05-27 11:33

Pushed. but as it doesn't fix the problem of the "presentation of alises in mariadbd --verbose --help being highly redundant", I don't know if this issue should be closed.

Sergei Golubchik added a comment - 2024-05-27 11:33 Pushed. but as it doesn't fix the problem of the "presentation of alises in mariadbd --verbose --help being highly redundant", I don't know if this issue should be closed.

Sergei Golubchik made changes - 2024-05-27 11:38

Priority

Critical [ 2 ]

Major [ 3 ]

Sergei Golubchik made changes - 2024-05-27 11:38

Fix Version/s

11.5 [ 29506 ]

Sergei Golubchik made changes - 2024-05-27 11:38

Assignee

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2024-06-29 13:03

Link

This issue includes ~~MDEV-25275~~ [ ~~MDEV-25275~~ ]

People

Assignee:: Unassigned

Reporter:: Daniel Lenski (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 11 Start watching this issue

Dates

Created:: 2022-05-25 22:42

Updated:: 2025-03-17 00:42

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Presentation of aliases in `mariadbd --verbose --help` is highly redundant

Details

Description

Examples of how options with multiple names are shown now

How these should be shown

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration