Search Results
https://dev.mysql.com/doc/refman/9.7/en/multiple-data-directories.html
Warning Normally, you should never have two servers that update data in the same databases. This may lead to unpleasant surprises if your operating system does not support fault-free system locking. If (despite this warning) you run multiple servers ... Each MySQL Instance on a machine should have its own data ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-source-configuration-options.html
On non-Windows systems, CMake checks to see whether MYSQL_CONFIG_EXECUTABLE is set. -DWITH_BOOST={system|path_name} This option specifies which BOOST header file to use when compiling Connector/C++ with an external dependency. The option value to ...
https://dev.mysql.com/doc/connector-cpp/9.7/en/connector-cpp-source-configuration-options.html
On non-Windows systems, CMake checks to see whether MYSQL_CONFIG_EXECUTABLE is set. -DWITH_BOOST={system|path_name} This option specifies which BOOST header file to use when compiling Connector/C++ with an external dependency. The option value to ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-plugins.html
The server plugin interface also enables plugins to expose status and system variables. Every server plugin must have a general descriptor that provides information to the plugin API, and a type-specific descriptor that provides information about ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-key-caches.html
If you want the association to take effect each time the server starts, one way to accomplish this is to use an option file: Include variable settings that configure your key caches, and an init_file system variable that names a file containing ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-statements-current-table.html
To change this value, set the performance_schema_max_sql_text_length system variable at server startup. The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system ...Of ...
https://dev.mysql.com/doc/refman/9.7/en/backup-methods.html
If the server was not started with that variable set, the directory location is the value of the tmpdir system variable. The location of this directory is the value of the system variable replica_load_tmpdir. To get a consistent backup, stop the ...
https://dev.mysql.com/doc/refman/9.7/en/creating-accounts.html
Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which are discussed in Section 8.2.3, “Grant Tables”. The server is free to ignore rows that become malformed as a result of such ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-redo-log-archiving.html
mysqlbackup may sometimes fail to keep pace with redo log generation on the backed up server while a backup operation is in progress, resulting in lost redo log records due to those records being overwritten. This issue most often occurs when there ...The redo log archiving feature addresses this issue by sequentially writing redo log records to an archive file in addition to the redo log ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-hints.html
Individual system variable descriptions indicate whether each variable is hintable; see Section 7.1.8, “Server System Variables”. One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, ...Changes to this variable affect execution of all subsequent queries; to affect one query differently from another, it is necessary to change optimizer_switch before each ...