PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
If compression or encryption are enabled, the effective file name (the name actually used to create the log file) differs from the configured file name because it has additional suffixes: If compression is enabled, the plugin adds a suffix of .gz.
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. Assume also that the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
Statement-based replication requires the consecutive auto-increment lock mode to ensure that auto-increment values are assigned in a predictable and repeatable order for a given sequence of SQL statements, whereas row-based replication is not ...
https://dev.mysql.com/doc/refman/8.0/en/json-creation-functions.html
Certain special characters are escaped with backslashes per the escape sequences shown in Table 14.23, “JSON_UNQUOTE() Special Character Escape Sequences”. The functions listed in this section compose JSON values from component elements.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-using-management-client.html
In NDB 8.0.22 and later, START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. Cluster backups are created by default in the BACKUP subdirectory of the DataDir on each data node. The backup files created for a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication configuration. A gap in the externalized transaction set appears when, given an ordered sequence of transactions, a ...This section explains how to avoid inconsistencies and solve any problems they ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). NDB Cluster stores foreign names using the same lettercase with which they are created. Creating a foreign key constraint requires the ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. This setting has no effect on tables created using any other storage engine than InnoDB. row ...When ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. Another option for creating accounts is to use the GUI tool MySQL Workbench. This section discusses the following ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...