Search Results
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue through the connection, the server determines what operation you want to perform, then checks whether your privileges are sufficient. For ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Consequently, database and table names are case-sensitive in MySQL Server on operating systems that have case-sensitive file names (such as most Unix systems). (In MySQL Server, these functions can take a variable number of arguments.) The ... MySQL ...If you add a version number after the ! character, the syntax within the comment is executed only if the MySQL version is greater than or equal to the specified version ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-format.html
Early-Startup Logging Output Format The server generates some error log messages before startup options have been processed, and thus before it knows error log settings such as the log_error_verbosity and log_timestamps system variable values, and ...log_sink_internal Output Format log_sink_json Output Format log_sink_syseventlog Output Format Early-Startup Logging Output Format System Variables That Affect Error Log Format log_sink_internal Output Format The internal log sink produces traditional error log ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-multi-source.html
Such a case is shown here: Figure 25.17 NDB Cluster Multi-Source Replication, With MySQL Servers MySQL servers acting as replicas must be run with the system variable log_replica_updates enabled. Note Using the log_replica_updates system variable ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-background.html
Moreover, as servers are cooperating together to create the group several other classic distributed systems problems have to be dealt with, such as network partitioning or split brain scenarios. In other words, to have multiple servers agreeing on ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.4/en/no-login-pluggable-authentication.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The file must be located in the directory named by the plugin_dir system variable. The ...Use ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. An ...It ...
https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html
SHOW REPLICAS should be executed on a server that acts as a replication source. Host: The host name of the replica server, as specified on the replica with the --report-host option. This can differ from the machine name as configured in the ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-encrypted-connections.html
To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables used with MySQL Server. At initialization, X Plugin determines its TLS context ...These variables are described at Section 22.5.6.2, “X Plugin Options and System ...For example, X Plugin can have SSL key, ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
When optimizing and tuning the backup procedure, measure both the raw performance (how long it takes the backup to complete) and the amount of overhead on the database server. Compressed Backup Compressing the backup data before transmitting it to ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...