PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
(The practical limit is less than 3000.) A table can have no more than 255 unique element list definitions among its ENUM and SET columns considered as a group. A table can have no more than 255 unique element list definitions among its ENUM and SET ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 6.4.5.1, “Elements of MySQL Enterprise Audit”. For general information about ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
A group of MySQL servers can be configured to create a cluster using MySQL Shell. It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
To prevent this, enable the sync_binlog system variable to synchronize the binary log to disk after every N commit groups. The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
To start the server as the given user automatically at system startup time, specify the user name by adding a user option to the [mysqld] group of the /etc/my.cnf option file or the my.cnf option file in the server's data directory. On Windows, you ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
For example, the following statements behave as expected for all except certain Group Replication channels: START SLAVE starts replication threads for all channels, except the group_replication_recovery and group_replication_applier channels. STOP ... When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific ...
https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html
There is one subsection for each group of related character sets. To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To avoid choosing the ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
InnoDB permits a foreign key to reference any index column or group of columns. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
If a string return value should be in a different character set, convert it. The following example shows how to convert the result of gen_rnd_email() to the utf8mb4 character set: SET @email = CONVERT(gen_rnd_email() USING utf8mb4); It may also be ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
On Windows, there is currently a limit to the number of (logical) processors that mysqld can use: a single processor group, which is limited to a maximum of 64 logical processors. Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance ...