Search Results
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-5-0.html
(Bug #38055488) Binary Logging Important Change: The default value for the binlog_transaction_dependency_history_size server system variable has been increased from 25000 to 1000000 (one million). (Bug #38178087) The server plugin system variable ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-mysql-cluster.html
You can determine whether your MySQL Server has NDB support using one of the statements SHOW VARIABLES LIKE 'have_%', SHOW ENGINES, or SHOW PLUGINS. What file systems can I use with NDB Cluster? What about network file systems or network shares? ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbd-definition.html
ServerPort Version (or later) NDB 9.7.0 Type or units unsigned Default [...] Range 1 - 64K Restart Type System Restart: Requires a complete shutdown and restart of the cluster. (For example, 100K means 100 × 1024 = 102400.) Parameter names and ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-1-0.html
The maximum number of open tables which have fully loaded triggers and which are held in the table cache at any given time is determined by the value of the server system variable table_open_cache_triggers, which is added in this release. row ...
https://dev.mysql.com/doc/refman/9.7/en/import-table.html
For example, the .sdi file can be placed in the directory named by the secure_file_priv system variable, or (if secure_file_priv is empty) in a directory under the server data directory. The import server uses /tmp/mysql-files as the directory named ...The example uses these assumptions (to perform a similar operation on your own system, modify the path names as appropriate): For the export server, export_basedir represents its base directory, and its data directory is ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-plugin.html
Also, set the keyring_okv_conf_dir system variable to tell keyring_okv where to find its configuration directory. For additional information about keyring_okv_conf_dir, see Section 8.4.5.19, “Keyring System Variables”. Create the configuration ...The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-files-using-openssl.html
(The CA certificate, if used, must be the same on both sides.) server-cert.pem, server-key.pem: Use these to set the ssl_cert and ssl_key system variables on the server side. When the installation has finished, add C:\OpenSSL-Win32\bin to the ...The ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-rpm.html
See Section 2.5.9, “Managing MySQL Server with systemd” for additional information. From the Download MySQL Community Server page in the MySQL Developer Zone. mysql-commercial-server Database server and related tools mysql-commercial-test Test ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...
https://dev.mysql.com/doc/refman/9.7/en/windows-start-service.html
To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable: On the Windows desktop, right-click the My Computer icon, and select Properties. Next select the ...A ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/9.7/en/upgrade-binary-package.html
For some Linux platforms, MySQL installation from RPM or Debian packages includes systemd support for managing MySQL server startup and shutdown. In such cases, use systemd for server startup and shutdown instead of the methods used in the following ...In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or packages with the new ones, restarting MySQL on the existing data directory, and upgrading any remaining parts of the existing installation that require ...