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/replication-solutions-unexpected-replica-halt.html
In MySQL 5.7 you can instead use an InnoDB table named mysql.slave_relay_log_info to store the applier metadata repository. To configure MySQL 5.7 to store the applier metadata repository as an InnoDB table, set the system variable ... In order for ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
OFF WITH_EXTRA_CHARSETS Which extra character sets to include all WITH_GMOCK Path to googlemock distribution WITH_INNODB_EXTRA_DEBUG Whether to include extra debugging support for InnoDB. The InnoDB, MyISAM, MERGE, MEMORY, and CSV engines are ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. The plugin table uses the InnoDB storage engine as of MySQL 5.7.6, MyISAM before that. These tables use the InnoDB storage engine as of MySQL 5.7.5, ...It ...
https://dev.mysql.com/doc/refman/5.7/en/table-locking.html
InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. MySQL uses table locking (instead of page, ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
If a transaction-safe engine such as InnoDB is being used, a transaction is either completed on the replica or not applied at all, but replication does not guarantee that all data on the source and the replica remains consistent at all times. NDB ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
Stopwords for InnoDB Search Indexes Stopwords for MyISAM Search Indexes Stopwords for InnoDB Search Indexes InnoDB has a relatively short list of default stopwords, because documents from technical, literary, and other sources often use short words ... The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system ...
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/commit.html
The effect is the same as issuing a START TRANSACTION followed by a SELECT from any InnoDB table. MySQL enables extra optimizations for queries on InnoDB tables when the transaction is known to be read-only. To disable autocommit mode explicitly, ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
Auto-Increment Columns If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value is not reused for a MyISAM or InnoDB table. If you delete all rows in the table with DELETE FROM tbl_name (without a WHERE clause) in ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
For example, to make two-character words searchable, you could put the following lines in an option file: [mysqld] innodb_ft_min_token_size=2 ft_min_word_len=2 Then restart the server and rebuild your FULLTEXT indexes. (InnoDB does not have an ...