MariaDB Enterprise Server 11.6.4-1 is the first Stable (GA) release of MariaDB Enterprise Server 10.6, released on 2021-08-26
MariaDB Enterprise Server 10.6.4-1 is the first Stable, General Availability (GA) release of MariaDB Enterprise Server 10.6. This release contains a variety of new features.
MariaDB Enterprise Server 10.6.4-1 was released on 2021-08-26.
CVE (with link)
CVSS base score
Extensive internal optimizations, including a refactoring of code.
Atomic DDL
DDL (Data Definition Language) statements are now atomic operations. If the DDL statement is not fully successful, the operation will be rolled back. When the server crashes or is killed in the middle of a DDL statement, the operation is rolled back during crash recovery when the server is restarted. ()
This release incorporates . Benefits include:
Disk-based aggregation allows larger aggregated result sets than can fit in memory
Increased DECIMAL precision
Transactional tables can be updated with data from ColumnStore tables
Default InnoDB flush method
(This item is also mentioned above in .)
The default is now O_DIRECT ()
Prior to this release, the default
Compressed rows read-only by default
row format is read-only by default. ()
System variable by default.
System variable innodb_read_only_compressed=OFF
For additional information, see "" and "".
Information Schema changes for InnoDB
Information Schema directly reflects the filesystem. ()
INNODB_SYS_TABLESPACES.PAGE_SIZE
Expanded compatibility with Oracle through new functions:
Added function ()
Added function ()
Added function ()
sys Schema
sys schema provides a set of views, functions, and stored procedures to aid DBA analysis of the . ()
Increase in host name length
Host names in ,
Example syntax for CREATE INDEX:
Example syntax for ALTER TABLE:
An ignored index cannot be referenced in index hints, such as FORCE INDEX, IGNORE INDEX, or USE INDEX. When you try to reference an ignored index in an index hint, the server raises an error with the error code:
Thread Pool enhancements
The thread pool can be configured to reshuffle connections into random thread groups periodically, which can help prevent many connections from becoming concentrated in just a few thread groups. (MENT-622)
The thread_pool_reshuffle_group_period system variable defines how frequently the connections are reshuffled. By default, the value is 0 which means that connections are not reshuffled.
The THREAD_POOL_CONNECTIONS information schema table can be used to view which connections are assigned to each thread group.
JSON_TABLE()
returns a table from JSON data. ()
Queryable rows and columns are produced based on the JSON input, but are not stored in a table on disk. Column mappings are defined in a JSON path expression.
Prior to this release, the and functions could be used to retrieve values from JSON data on a per-column basis.
For example, the following query specifies ONLY instead of WITH TIES, so the query can't return more than 10 rows:
Views supported with ()
All SQL statements can be prepared except , , [DEALLOCATE / DROP ()
allows database-specific and table-specific filters. (MENT-65) For example:
The authentication plugin can now authenticate a user account by checking if the user belongs to an Active Directory group. ()
The group is specified in the authentication string using the statement. The group can be specified using the group name or the SID.
Example syntax using a group name without specifying the domain:
Example syntax using a group name that specifies the domain:
Example syntax using a SID in the usual format:
Example syntax using a well-known SID:
When using data-at-rest encryption with the encryption plugin, InnoDB will automatically disable key rotation checks. ()*
The encryption plugin does not support key rotation, so key rotation checks are not required.*
In previous releases, unnecessary key rotation checks with the encryption plugin could hurt performance, unless they were explicitly disabled by setting .
Performance Schema table provides information on replica worker threads. ()
Fine-grained binlog expiration
system variable defines the frequency in seconds of automated removal of binary logs. ()
Prior to this release, expiration time was defined in days using binlog_expire_logs_days.
MariaDB Enterprise Cluster is powered by Galera. New in this release:
XA Transactions are supported (MENT-690)
With , TLS is required for MariaDB Enterprise Cluster by default. (MENT-1192)
Since TLS is required for Enterprise Cluster by default, database administrators should create TLS certificates for each node during the deployment process.
Database administrators can revert Enterprise Cluster to the mode used in previous releases by setting the
The following changes are as compared to MariaDB Enterprise Server 10.5.10-7, the latest GA release on the prior release series.
For clients such as mariadb (mysql), the connection property specified via the command-line (such as --port=3306) will force the connection type (such as TCP/IP). ()
Unchanged metadata is not sent in the result set for prepared statements. ()
function added
In alignment to the , MariaDB Enterprise Server 10.6.4-1 is provided for:
CentOS 7
Debian 9
Debian 10
Microsoft Windows
Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see "".
By default, the DDL log is at ddl-recovery.log in the . When DDL statements are being executed, the DDL log is synchronized to disk very frequently. If you want to configure a custom path for the DDL log, the log-ddl-recovery option can be used.
Default InnoDB flush method
The default innodb_flush_method is now O_DIRECT (MDEV-24854)
Prior to this release, the default innodb_flush_method was fsync
UTF-8 (utf8) character set alias
The character set has been renamed to , which used to be an alias for the utf8 character set
The character set utf8 is now an alias that defaults to utf8mb3 but can be turned into an alias for with a config change
The new default of is what makes utf8mb3 default to utf8, and anything that removes this new value from old_mode changes utf8 to mean utf8mb4 ()
In a future release series (after 10.6) the default value of old_mode will drop this new value, making utf8 default to utf8mb4
IPv6 by Default (MDEV-6536)
When is configured, MariaDB Enterprise Server now listens on both IPv6 and IPv4 addresses.
LZ4 compression
fsyncSELECT .. SKIP LOCKED
ignores already-locked rows. (MDEV-13115)
One use case for this feature is within applications that sell a limited resource, such as ticketing, rentals, or seat-based sales. In these applications, you need a way to display only the available inventory. This can be accomplished by querying available inventory and skipping locked rows.
This is a preparatory change. Additional change will occur in a future release series (after 10.6), when COMPRESSED row format will no longer accept writes. It is recommended to alter tables using the COMPRESSED row format to use the DYNAMIC row format with InnoDB page compression:
INNODB_SYS_TABLESPACES.FILENAME added as a replacement for
Information Schema INNODB_SYS_DATAFILES removed. (MDEV-22343)
Reduced global lock duration in InnoDB transaction deadlock checks (MDEV-24738)
InnoDB no longer acquires advisory file locks by default (MDEV-24393)
When using data-at-rest encryption with the encryption plugin, InnoDB will automatically disable key rotation checks. (MDEV-14180)*
The encryption plugin does not support key rotation, so key rotation checks are not required.*
In previous releases, unnecessary key rotation checks with the encryption plugin could reduce performance, unless they were explicitly disabled by setting innodb_encryption_rotate_key_age=0.
Optimization added to speed up inserts into an empty InnoDB table. (MDEV-515)
Maximum value of the innodb_lock_wait_timeout system variable is now 100000000, which means infinite timeout.
Change in checksum algorithm options
innodb_checksum_algorithm options have changed: (MDEV-25105)
Supported: crc32, strict_crc32, full_crc32, strict_full_crc32
Eliminated: none, strict_none, innodb, strict_innodb
When InnoDB reads a page using an eliminated checksum algorithm after performing a physical upgrade, InnoDB will continue to accept the checksum.
When a query changes a page using an eliminated checksum algorithm, InnoDB will automatically switch to a supported checksum algorithm when InnoDB writes the changed page to disk.
Added function (MDEV-20017)
Expanded compatibility with Oracle through enhancements:
With sql_mode=ORACLE added MINUS as an alias to EXCEPT (MDEV-20021)
With sql_mode=ORACLE improved SYSDATEto allow use without parenthesis. ()
With sql_mode=ORACLE supports a pseudo-column name as an alias for the function ()
With sql_mode=ORACLE subqueries in a FROM clause do not require the AS clause.
Enhanced compatibility with Sybase SQL Anywhere through : (MENT-1062)
With sql_mode=EXTENDED_ALIASES, alias resolution and use of column aliases in the SQL list and WHERE clause.
With sql_mode=EXTENDED_ALIASES, support use of an alias in the list before the alias is defined.
With sql_mode=EXTENDED_ALIASES, if the same label is used for an alias and a column, the alias is used.
UTF8
(This item is also mentioned above in Notable Changes .)
The character set has been renamed to , which was formerly an alias for the utf8 character set
The character set utf8 is now an alias that defaults to utf8mb3 but can be turned into an alias for with a config change
The new default of is what makes utf8mb3 default to utf8, and anything that removes this new value from old_mode changes utf8 to mean utf8mb4 (MDEV-8334)
In a future release series (after 10.6) the default value of old_mode will drop this new value, making utf8 default to utf8mb4
Ignored indexes
An index can be marked with the IGNORED option, which forbids the optimizer from using the index in queries. The IGNORED option can be used to evaluate whether an index is actually helpful for performance without dropping the index. (MDEV-7317)
Example syntax for CREATE TABLE:
Systemd
Systemd socket activation is now supported. (MDEV-5536)
With JSON_TABLE():
JSON data can JOIN with existing tables.``
A table can be created from JSON data using against a JSON_TABLE().
enables extraction of nested data from JSON arrays and objects.
OFFSET syntax
Additional syntax is supported for (MDEV-23908)
OFFSET start { ROW | ROWS } FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES } is an alternative to LIMIT .. OFFSET
The WITH TIES option requires the use of ORDER BY and allows the number of rows to exceed the FETCH count to ensure that the final row in the chunk includes any additional rows that have the same values in the ORDER BY fields (eliminating the need to fetch the next chunk to check for spill-over).
For example, the following query can return more than 10 rows if there are more username rows that match the username in the 10th row (the order of the purchase values within the complete set of each username's records is non-deterministic):
Since TLS is required for Enterprise Cluster by default, database administrators should create TLS certificates for each node during the deployment process.
Database administrators can revert Enterprise Cluster to the mode used in previous releases by setting the wsrep_ssl_mode system variable to PROVIDER.
For additional information, see "WSREP TLS Modes".
TLS functionality for State Snapshot Transfers (SSTs) is enhanced when MariaDB Enterprise Backup or Rsync is the SST method. (MDEV-25359)
For additional information, see "SST TLS Modes".
Cluster name verification is performed for Joiner nodes prior to State Snapshot Transfers (SSTs) and Incremental State Transfers (ISTs). (MDEV-25359) For additional information, see "Cluster Name Verification".
With MariaDB Enterprise Cluster, system variable enables logging of a warning prior to expiration of the TLS certificate used for wsrep (Enterprise Cluster) communications. (MENT-1090)
For additional information, see "Certificate Expiration Warnings".
With MariaDB Enterprise Cluster, communication between nodes can be changed from unencrypted to TLS without cluster downtime. (MDEV-22131)
Enabling TLS without downtime relies on two new options implemented for the system variable: socket.dynamic and socket.ssl_reload.
For additional information, see "".
Enhanced consistency for Semi-Sync Replication
When , consistency is guaranteed for a Primary server in an HA (Primary/Replica) topology when using semi-synchronous replication. (MDEV-21117)
rior to this release, when using semi-synchronous replication, if a Primary crashed before sending a transaction to the Replica, on restart the Primary could recover incomplete InnoDB transactions when rejoining as a Replica.
With this release, when using semi-synchronous replication and with rpl_semi_sync_slave_enabled=ON, incomplete transactions will be rolled-back on the Replica, ensuring the new Primary (former Replica) and new Replica (former Primary) remain in sync.
PROVIDERFor additional information, see "".
TLS functionality for State Snapshot Transfers (SSTs) is enhanced when MariaDB Enterprise Backup or Rsync is the SST method. (MDEV-25359)
For additional information, see "".
Cluster name verification is performed for Joiner nodes prior to State Snapshot Transfers (SSTs) and Incremental State Transfers (ISTs). (MDEV-25359)
For additional information, see "Cluster Name Verification".
system variable enables logging of a warning prior to expiration of the TLS certificate used for wsrep (Enterprise Cluster) communications. (MENT-1090)
For additional information, see "Certificate Expiration Warnings".
Communication between nodes can be changed from unencrypted to TLS without cluster downtime. (MDEV-22131)
Enabling TLS without downtime relies on two new options implemented for the system variable: socket.dynamic and socket.ssl_reload.
For additional information, see "".
Galera Cluster nodes can be configured to refuse statements that would generate local GTIDs. (MDEV-20715)
When Galera Cluster is used with MariaDB Replication, local GTIDs can cause replication errors when the primary or replica has to failover to a different cluster node. By configuring Galera Cluster nodes to refuse statements that would generate local GTIDs, replication is more likely to succeed against any available cluster node.
To configure a node to refuse statements that would generate local GTIDs, set .
replaces deprecated system variable (MDEV-20008)
replaces deprecated system variable (MDEV-24946)
When and wsrep_OSU_method=TOI, information about DDL queries from remote hosts is logged in the local error log, not just locally-initiated DDL queries. (MDEV-9609)
The default of disables debug logging.
The script wsrep_sst_mariadb-backup checks all server-related configuration groups when processing a configuration file. (MDEV-25669)
Prior to this release, only the [mysqld] configuration group was checked when processing a configuration file.
system variable added
columnstore_cache_use_import system variable added
columnstore_decimal_overflow_check system variable added
status variable removed
ER_BINLOG_UNSAFE_SKIP_LOCKED error code added
ER_BLACKBOX_ERROR error code error number changed from 4174 to 6000
ER_JSON_TABLE_ALIAS_REQUIRED error code added
ER_JSON_TABLE_ERROR_ON_FIELD error code added
ER_JSON_TABLE_MULTIPLE_MATCHES error code added
ER_JSON_TABLE_SCALAR_EXPECTED error code added
ER_PK_INDEX_CANT_BE_IGNORED error code added
ER_REMOVED_ORPHAN_TRIGGER error code added
ER_STORAGE_ENGINE_DISABLED error code added
ER_UNSUPPORTED_COMPRESSED_TABLE error code replaces ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE
ER_UNUSED_26 error code replaces ER_COMMULTI_BADCONTEXT
ER_UNUSED_27 error code replaces ER_BAD_COMMAND_IN_MULTI
ER_UNUSED_28 error code replaces ER_TABLE_IN_FK_CHECK
ER_WITH_TIES_NEEDS_ORDER error code added
system variable default value changed from 0 to 0.000000
performance schema table added
performance schema table added
sys table added
sys table added
sys table added
sys table added
sys table added
sys table added
innochecksum --strict-check (-C) command-line option removed
innochecksum --write (-w) command-line option removed
innodb_adaptive_max_sleep_delay system variable removed
innodb_background_scrub_data_check_interval system variable removed
innodb_background_scrub_data_compressed system variable removed
innodb_background_scrub_data_interval system variable removed
innodb_background_scrub_data_uncompressed system variable removed
innodb_buffer_pool_instances system variable removed
Innodb_buffer_pool_pages_lru_freed status variable added
innodb_buffer_stats_by_schema sys table added
innodb_buffer_stats_by_table sys table added
innodb_commit_concurrency system variable removed
innodb_concurrency_tickets system variable removed
innodb_deadlock_report system variable added
innodb_file_format system variable removed
innodb_flush_method system variable default value changed from fsync to O_DIRECT
innodb_large_prefix system variable removed
innodb_lock_schedule_algorithm system variable removed
innodb_lock_wait_timeout system variable maximum value changed from 1073741824 to 100000000
innodb_lock_waits sys table added
innodb_log_checksums system variable removed
innodb_log_compressed_pages system variable removed
innodb_log_files_in_group system variable removed
innodb_log_optimize_ddl system variable removed
INNODB_MUTEXES information schema table removed
INNODB_MUTEXES plugin removed
innodb_page_cleaners system variable removed
innodb_read_only_compressed system variable added
innodb_replication_delay system variable removed
innodb_scrub_log System Variable system variable removed
innodb_scrub_log_speed system variable removed
innodb_sync_array_size system variable removed
INNODB_SYS_DATAFILES information schema table removed
INNODB_SYS_DATAFILES plugin removed
INNODB_SYS_SEMAPHORE_WAITS information schema table removed
INNODB_SYS_SEMAPHORE_WAITS plugin removed
innodb_thread_concurrency system variable removed
innodb_thread_sleep_delay system variable removed
innodb_undo_logs system variable removed
sys table added
sys table added
sys table added
sys table added
sys table added
function added
information schema table added
sys table added
mariadb-backup --debug-sleep-before-unlock command-line option removed
mariadb-backup --debug-sync command-line option removed
mariadb-backup --innodb-log-files-in-group command-line option removed
mariadbd command-line option added
mariadbd --columnstore-cache-use-import command-line option added
mariadbd --columnstore-decimal-overflow-check command-line option added
mariadbd --innodb-adaptive-max-sleep-delay command-line option removed
mariadbd --innodb-background-scrub-data-check-interval command-line option removed
mariadbd --innodb-background-scrub-data-compressed command-line option removed
mariadbd --innodb-background-scrub-data-interval command-line option removed
mariadbd --innodb-background-scrub-data-uncompressed command-line option removed
mariadbd --innodb-buffer-pool-instances command-line option removed
mariadbd --innodb-commit-concurrency command-line option removed
mariadbd --innodb-concurrency-tickets command-line option removed
mariadbd --innodb-deadlock-report command-line option added
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option added
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option removed
mariadbd command-line option added
mariadbd command-line option added
mariadbd command-line option added
mariadbd command-line option added
mariadbd command-line option added
mariadbd option added
mariadbd wsrep-ssl-mode command-line option added
system variable default value changed from 4294967295 to 1000 (MDEV-17239)
sys table added
sys table added
sys table added
sys table added
sys table added
sys table added
MINUS reserved word added
OFFSET reserved word added
system variable default value changed from "" (empty) to UTF8_IS_UTF8MB3
processlist sys table added
ps_check_lost_instrumentation sys table added
Resultset_metadata_skipped status variable added
function added
ROWNUM reserved word added
sys table added
schema_index_statistics sys table added
sys table added
schema_redundant_indexes-sys-schema-view sys table added
sys table added
schema_table_statistics-sys-schema-view sys table added
schema_table_statistics_with_buffer-sys-schema-viewsys table added
schema_schema_tables_with_full_table_scansobject_overview-sys-schema-view sys table added
schema_unused_indexes-sys-schema-view sys table added
server_audit_load_on_error system variable added
session sys table added
session_ssl_status sys table added
information schema table added
sql_mode value EXTENDED_ALIASES added
statement_analysis sys table added
statements_with_errors_or_warnings sys table added
statements_with_full_table_scans sys table added
statements_with_runtimes_in_95th_percentile sys table added
statements_with_sorting sys table added
statements_with_temp_tables sys table added
[SYS_GUID|[SYS_GUID()]] function added
SYSDATE reserved word added
system_versioning_asof system variable default value changed from DEFAULT to "" (empty)
THREAD_POOL_CONNECTIONS information schema table added
THREAD_POOL_CONNECTIONS plugin added
thread_pool_reshuffle_group_period system variable added
function added
user_summary sys table added
user_summary_by_file_io sys table added
user_summary_by_file_io_type sys table added
user_summary_by_stages sys table added
user_summary_by_statement_latency sys table added
user_summary_by_statement_type sys table added
version sys table added
wait_classes_global_by_avg_latency sys table added
wait_classes_global_by_latency sys table added
waits_by_host_by_latency sys table added
waits_by_user_by_latency sys table added
waits_global_by_latency sys table added
wsrep_certificate_expiration_hours_warning system variable added
variable added
wsrep_ssl_mode system variable added
sys table added
sys table added
sys table added
sys table added
sys table added
sys table added
hinnodb_buffer_stats_by_schema-and-xinnodb_buffer_stats_by_schema-sys-schema-views sys table added
sys table added
sys table added
sys table added
sys table added
io_global_by_file_by_latency-and-xio_global_by_file_by_latency-sys-schema-views sys table added
sys table added
io_global_by_wait_by_latency-and-xio_global_by_wait_by_latency-sys-schema-views sys table added
sys table added
memory_by_host_by_current_bytes-and-xmemory_by_host_by_current_bytes-sys-schema-views sys table added
memory_by_thread_by_current_bytes-and-xmemory_by_thread_by_current_bytes-sys-schema-views sys table added
memory_by_user_by_current_bytes-and-xmemory_by_user_by_current_bytes-sys-schema-views sys table added
memory_global_by_current_bytes-and-xmemory_global_by_current_bytes-sys-schema-views sys table added
memory_global_total-and-xmemory_global_total-sys-schema-views sys table added
processlist-and-xprocesslist-sys-schema-views sys table added
ps_digest_95th_percentile_by_avg_usy-and-xps_digest_95th_percentile_by_avg_us-sys-schema-views sys table added
hps_digest_avg_latency_distribution-and-xps_digest_avg_latency_distribution-sys-schema-views sys table added
ps_schema_table_statistics_io-and-xps_schema_table_statistics_io-sys-schema-views sys table added
schema_flattened_keys-and-xschema_flattened_keys-sys-schema-views sys table added
schema_index_statistics-and-xschema_index_statistics-sys-schema-views sys table added
schema_table_lock_waits-and-xschema_table_lock_waits-sys-schema-views sys table added
schema_table_statistics-and-xschema_table_statistics-sys-schema-views sys table added
schema_table_statistics_with_buffer-and-xschema_table_statistics_with_buffer-sys-schema-views sys table added
schema_tables_with_full_table_scans-and-xschema_tables_with_full_table_scans-sys-schema-views sys table added
session-and-xsession-sys-schema-views sys table added
statement_analysis-and-xstatement_analysis-sys-schema-views sys table added
statements_with_errors_or_warnings-and-xstatements_with_errors_or_warnings-sys-schema-views sys table added
statements_with_full_table_scans-and-xstatements_with_full_table_scans-sys-schema-views sys table added
statements_with_runtimes_in_95th_percentile-and-xstatements_with_runtimes_in_95th_percentile-sys-schema-view sys table added
statements_with_sorting-and-xstatements_with_sorting-sys-schema-views sys table added
statements_with_temp_tables-and-xstatements_with_temp_tables-sys-schema-views sys table added
user_summary-and-xuser_summary-sys-schema-views sys table added
user_summary_by_file_io-and-xuser_summary_by_file_io-sys-schema-views sys table added
user_summary_by_file_io_type-and-xuser_summary_by_file_io_type-sys-schema-views sys table added
user_summary_by_stages-and-xuser_summary_by_stages-sys-schema-views sys table added
user_summary_by_statement_latency-and-xuser_summary_by_statement_latency-sys-schema-views sys table added
user_summary_by_statement_type-and-xuser_summary_by_statement_type-sys-schema-views sys table added
wait_classes_global_by_avg_latency-and-xwait_classes_global_by_avg_latency-sys-schema-views) sys table added
wait_classes_global_by_latency-and-xwait_classes_global_by_latency-sys-schema-views sys table added
waits_by_host_by_latency-and-xwaits_by_host_by_latency-sys-schema-views sys table added
waits_by_user_by_latency-and-xwaits_by_user_by_latency-sys-schema-views sys table added
waits_global_by_latency-and-xwaits_global_by_latency-sys-schema-views sys table added
Red Hat Enterprise Linux 8
SUSE Linux Enterprise Server 12
SUSE Linux Enterprise Server 15
Ubuntu 18.04
Ubuntu 20.04
5.5
SELECT *
FROM ticketing
WHERE claimed = 0 AND section = 'B'
ORDER BY row DESC
LIMIT 10
FOR UPDATE SKIP LOCKED;ALTER TABLE tab
ROW_FORMAT=DYNAMIC
PAGE_COMPRESSED=1;CREATE TABLE table_name (
id INT PRIMARY KEY,
col_name INT,
INDEX key_name (col_name) IGNORED
);CREATE INDEX key_name
ON table_name
(col_name) IGNORED;ALTER TABLE table_name
ALTER INDEX key_name IGNORED;SELECT *
FROM table_name
FORCE INDEX (key_name)
WHERE col_name > 1;ERROR 1176 (42000): Key 'key_name' doesn't exist in table 'table_name'SELECT username, purchase
FROM user_purchases
ORDER BY username
OFFSET 305 ROWS
FETCH NEXT 10 ROWS WITH TIES;SELECT username, purchase
FROM user_purchases
ORDER BY username, purchase
OFFSET 0 ROWS
FETCH NEXT 10 ROWS ONLY;{
"connect_event" : "ALL",
"table_event" : ["READ","WRITE",{"ignore_tables" : "mysql.*"}],
"query_event" : ["DDL",{"tables" : "test.t2"}]
}CREATE USER root
IDENTIFIED VIA gssapi AS 'GROUP:Administrators';CREATE USER root
IDENTIFIED VIA gssapi AS 'GROUP:Administrators';CREATE USER root
IDENTIFIED VIA gssapi AS 'SID:S-1-5-32-544';CREATE USER everyone
IDENTIFIED VIA gssapi AS 'SID:WD';This page is: Copyright © 2025 MariaDB. All rights reserved.