PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
After this, all tables created in the database mydb are created in D:\data\mydb. After this, all tables created in the database mydb are created in D:\data\mydb. To do this, create a symbolic link in the MySQL data directory that points to ... On ...
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
Many option files are plain text files, created using any text editor. It is created by the server upon execution of SET PERSIST or SET PERSIST_ONLY statements. If an option file you want to use does not exist, create it using the appropriate ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
Signals can be raised within exception handlers: CREATE PROCEDURE p () BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN SIGNAL SQLSTATE VALUE '99999' SET MESSAGE_TEXT = 'An error occurred'; END; DROP TABLE no_such_table; END; CALL p() reaches the ...Without SIGNAL, it is necessary to resort to workarounds such as deliberately referring to a nonexistent table to cause a routine to return an ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
CMake Option Reference General Options Installation Layout Options Storage Engine Options Feature Options Compiler Flags CMake Options for Compiling NDB Cluster CMake Option Reference The following table shows the available CMake options. The CMake ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
InnoDB tablespace files and file-per-table tablespaces might have been created in other directories. Note If the replication source server or existing replica that you are copying to create the new replica has any scheduled events, ensure that these ... You can add another replica to an existing replication configuration without stopping the source ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as appropriate. pub_key_str and priv_key_str are valid PEM encoded key strings that were created using the DH algorithm. Then this ... In ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. If caching_sha2_password is the default authentication plugin, a simpler CREATE USER syntax can be used. As a result, it is possible to create the account and set its ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump ...You can then transfer the file to the other machine and feed it as input to the mysql ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. If a session has open temporary tables, the replication format cannot be changed for the session (SET @@SESSION.binlog_format). If any ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
Wait event data collected in Performance Schema tables can help identify mutexes with the most waits or the greatest total wait time, for example. To view available InnoDB mutex wait instruments, query the Performance Schema setup_instruments table.