Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/performance-schema-processlist-table.html
Note If the performance_schema_show_processlist system variable is enabled, the processlist table also serves as the basis for an alternative implementation underlying the SHOW PROCESSLIST statement. A value of system user refers to a nonclient ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/install-plugin.html
The shared library must be located in the plugin directory (the directory named by the plugin_dir system variable). By default, plugin_dir is the plugin directory under the directory named by the pkglibdir configuration variable, but it can be ...
https://dev.mysql.com/doc/refman/9.7/en/installing-development-tree.html
To obtain the MySQL Server source code from this repository hosting service, you can set up a local MySQL Git repository. On GitHub, MySQL Server and other MySQL projects are found on the MySQL page. The MySQL Server project is a single repository ... This section describes how to install MySQL from the latest development source code, which is hosted on ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/keyring-okv-component.html
Variables that are persisted (saved to mysqld-auto.cnf) must be removed from the server's configuration using RESET PERSIST. The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management ...
https://dev.mysql.com/doc/ndb-operator/9.7/en/crd-ndbmysqldspec.html
MySQL Server Options and Variables for NDB Cluster, provides a reference of MySQL Server configuration options specific to NDB Cluster. NdbMysqldSpec is the specification for any MySQL Servers to be run as NDB Cluster SQL nodes. nodeCount ...See ...
https://dev.mysql.com/doc/refman/9.7/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/refman/9.7/en/federated-description.html
When you create a FEDERATED table, the table definition is the same, but the physical storage of the data is handled on a remote server. A FEDERATED table consists of two elements: A remote server with a database table, which in turn consists of the ... When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated ...