Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-storage-engines.html
It is not possible under normal circumstances in NDB Cluster to create an NDB Cluster table using any partitioning type other than [LINEAR] KEY, and attempting to do so fails with an error. In MySQL 8.4, partitioning support is not actually ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
Connection attributes are key-value pairs that application programs can pass to the server at connect time. For applications based on the C API implemented by the libmysqlclient client library, the mysql_options() and mysql_options4() functions ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-component-status-table.html
The keyring_component_status table provides status information about the properties of the keyring component in use, if one is installed. The table is empty if no keyring component is installed (for example, if the keyring is not being used, or is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-log-status-table.html
The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy process. When the log_status table is queried, the server blocks logging and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-table.html
This table holds the replica's source lists for each replication channel for the asynchronous connection failover mechanism. The asynchronous connection failover mechanism automatically establishes an asynchronous (source to replica) replication ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
This table shows the configuration parameters used by the replica for connecting to the source. Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement. It contains values that define how the replica ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-tables.html
The MySQL server maintains many status variables that provide information about its operation (see Section 7.1.10, “Server Status Variables”). Status variable information is available in these Performance Schema tables: global_status: Global ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
The Performance Schema maintains tables for collecting current and recent transaction events, and aggregates that information in summary tables. Section 29.12.7, “Performance Schema Transaction Tables” describes the events on which transaction ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. The server then authenticates the client, determining from ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...