diff options
Diffstat (limited to 'debian/tests/traces/mariadbd-verbose-help.expected')
| -rw-r--r-- | debian/tests/traces/mariadbd-verbose-help.expected | 31 |
1 files changed, 21 insertions, 10 deletions
diff --git a/debian/tests/traces/mariadbd-verbose-help.expected b/debian/tests/traces/mariadbd-verbose-help.expected index 601e8828..1c0f4be9 100644 --- a/debian/tests/traces/mariadbd-verbose-help.expected +++ b/debian/tests/traces/mariadbd-verbose-help.expected @@ -886,6 +886,9 @@ The following specify which files/extra groups are read (specified before remain Redo log size in bytes. --innodb-log-group-home-dir=name Path to ib_logfile0 + --innodb-log-spin-wait-delay[=#] + Delay between log buffer spin lock polls (0 to use a + blocking latch) --innodb-lru-flush-size=# How many pages to flush on LRU eviction --innodb-lru-scan-depth=# @@ -964,6 +967,8 @@ The following specify which files/extra groups are read (specified before remain --innodb-rollback-on-timeout Roll back the complete transaction on lock wait timeout, for 4.x compatibility (disabled by default) + --innodb-snapshot-isolation + Use snapshot isolation (write-write conflict detection). --innodb-sort-buffer-size=# Memory buffer size for index creation --innodb-spin-wait-delay[=#] @@ -1426,13 +1431,17 @@ The following specify which files/extra groups are read (specified before remain max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of file descriptors (Automatically configured unless set explicitly) - --optimizer-adjust-secondary-key-costs=# - 0 = No changes. 1 = Update secondary key costs for ranges - to be at least 5x of clustered primary key costs. 2 = - Remove 'max_seek optimization' for secondary keys and - slight adjustment of filter cost. This option will be - deleted in MariaDB 11.0 as it is not needed with the new - 11.0 optimizer. + --optimizer-adjust-secondary-key-costs=name + A bit field with the following values: + adjust_secondary_key_cost = Update secondary key costs + for ranges to be at least 5x of clustered primary key + costs. disable_max_seek = Disable 'max_seek optimization' + for secondary keys and slight adjustment of filter cost. + disable_forced_index_in_group_by = Disable automatic + forced index in GROUP BY. This variable will be deleted + in MariaDB 11.0 as it is not needed with the new 11.0 + optimizer. + Use 'ALL' to set all combinations. --optimizer-extra-pruning-depth=# If the optimizer needs to enumerate join prefix of this size or larger, then it will try aggressively prune away @@ -1479,7 +1488,7 @@ The following specify which files/extra groups are read (specified before remain extended_keys, exists_to_in, orderby_uses_equalities, condition_pushdown_for_derived, split_materialized, condition_pushdown_for_subquery, rowid_filter, - condition_pushdown_from_having, not_null_range_scan, + condition_pushdown_from_having, not_null_range_scan, hash_join_cardinality, cset_narrowing --optimizer-trace=name Controls tracing of the Optimizer: @@ -2658,6 +2667,7 @@ innodb-log-buffer-size 16777216 innodb-log-file-buffering FALSE innodb-log-file-size 100663296 innodb-log-group-home-dir (No default value) +innodb-log-spin-wait-delay 0 innodb-lru-flush-size 32 innodb-lru-scan-depth 1536 innodb-max-dirty-pages-pct 90 @@ -2689,6 +2699,7 @@ innodb-read-io-threads 4 innodb-read-only FALSE innodb-read-only-compressed FALSE innodb-rollback-on-timeout FALSE +innodb-snapshot-isolation FALSE innodb-sort-buffer-size 1048576 innodb-spin-wait-delay 4 innodb-stats-auto-recalc TRUE @@ -2829,7 +2840,7 @@ old-mode UTF8_IS_UTF8MB3 old-passwords FALSE old-style-user-limits FALSE open-files-limit 32000 -optimizer-adjust-secondary-key-costs 0 +optimizer-adjust-secondary-key-costs optimizer-extra-pruning-depth 8 optimizer-max-sel-arg-weight 32000 optimizer-max-sel-args 16000 @@ -2979,7 +2990,7 @@ slave-run-triggers-for-rbr NO slave-skip-errors OFF slave-sql-verify-checksum TRUE slave-transaction-retries 10 -slave-transaction-retry-errors 1158,1159,1160,1161,1205,1213,1429,2013,12701 +slave-transaction-retry-errors 1158,1159,1160,1161,1205,1213,1020,1429,2013,12701 slave-transaction-retry-interval 0 slave-type-conversions slow-launch-time 2 |