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/backup-and-recovery.html
If the primary fails, a secondary is automatically promoted to the role of primary, and MySQL Router routes requests to the new primary. It is important to back up your databases so that you can recover your data and be up and running again in case ...
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/charset-examples.html
Example 2: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci; This time we have a column with a latin1 character set and a default collation. The following ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
MATCH options do not have any other effect in MySQL, which in effect enforces MATCH SIMPLE semantics full-time. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent.
https://dev.mysql.com/doc/refman/5.7/en/faqs-migration.html
This may seem more complicated, but ultimately saves time and trouble. Where can I find information on how to upgrade or downgrade MySQL? A.8.2. How has storage engine (table type) support changed in MySQL 5.7 from previous versions? A.8.1. Where ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-security.html
Does MySQL include support for Roles Based Access Control (RBAC)? Not at this time. Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
Can the InnoDB data-at-rest feature store the master encryption key in an external device using the PKSC11 interface? Not at this time. Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
For InnoDB, all DML operations (INSERT, UPDATE, DELETE) involving columns with full-text indexes are processed at transaction commit time. Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT ...