Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
For durability and consistency in a replication setup that uses InnoDB with transactions: If binary logging is enabled, set sync_binlog=1. InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
You might also consider adding ANALYZE TABLE to setup scripts that you run after loading data, and running ANALYZE TABLE on a schedule at times of low activity. The persistent optimizer statistics feature improves plan stability by storing ...
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
A plugin is initialized by executing its initialization function, which handles any setup that the plugin must perform before it can be used. INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. It ...
https://dev.mysql.com/doc/refman/8.4/en/installing-development-tree.html
This section describes how to install MySQL from the latest development source code, which is hosted on GitHub. To obtain the MySQL Server source code from this repository hosting service, you can set up a local MySQL Git repository. On GitHub, ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its clients.
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
OpenLDAP provides an LDAP server, but a separate KDC server may be needed, with additional Kerberos setup required. Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
Be aware that they may differ from those built by Oracle in features, capabilities, and conventions (including communication setup), and that the installation instructions in this manual do not necessarily apply to them. The recommended way to ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation.html
Linux supports a number of different solutions for installing MySQL. You can also use My Oracle Support for the MySQL Enterprise Edition. Documentation Oracle Unbreakable Linux Network Use ULN channels Documentation As an alternative, you can use ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
For more complicated setups, you may want to remove some of the arguments and instead rely on a MySQL configuration file, such as my.cnf. macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL.
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
You might want to test a new MySQL release while leaving an existing production setup undisturbed. In some cases, you might want to run multiple instances of MySQL on a single machine. Or you might want to give different users access to different ...