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/keyring-key-migration.html
If you invoke the migration server from a system account different from that normally used to run MySQL, it might create keyring directories or files that are inaccessible to the server during normal operation. Any new directories or files created ... A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-plugin.html
Create the user if necessary and assign the user OCID to the keyring_oci_user system variable. Create these resources if necessary and make sure the user is enabled to use them. Create it if necessary and assign its OCID to the ... Note The ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Reserved words are permitted as identifiers if you quote them as described in Section 11.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ... Certain keywords, ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-native.html
To start the MySQL server use systemctl: $> systemctl start mysqld The database tables are automatically created for you, if they do not already exist. During installation, the initial database is created, and you are prompted for the MySQL root ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
To display the current structure of the log tables, use these statements: SHOW CREATE TABLE mysql.general_log; SHOW CREATE TABLE mysql.slow_log; Log contents are accessible through SQL statements. CREATE TABLE, ALTER TABLE, and DROP TABLE are valid ... MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
There are different methods of setting up a data directory for a new instance: Create a new data directory. Create a New Data Directory With this method, the data directory is in the same state as when you first install MySQL, and has the default ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-command-line-servers.html
To do this, create an option file for each server and tell the server the file name with a --defaults-file option when you run it. The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. In this case, it ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-docker.html
Downloading a MySQL NDB Cluster Docker Image Downloading the Docker image in a separate step is not strictly necessary; however, performing this step before you create your Docker containers ensures your local image is up to date. You can list ...