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/charset-collation-information-schema.html
Changing the value of lower_case_table_names to 1 or 2 causes the second query to return the same (nonempty) result as the first query. String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
Suppose that clients named user1 and user2 each connect one time from hosta and hostb. When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
To prevent various error conditions or corruptions, InnoDB checks file format compatibility when it opens a file (for example, upon first access to a table). The file format management capability in InnoDB 1.0 and higher (tablespace tagging and ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
This occurs when both of the following circumstances are true: Any session executes FLUSH TABLES or DDL statements on the handler's table. The session in which the handler is open executes non-HANDLER statements that use tables. HANDLER tbl_name ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. ACTION_STATEMENT The trigger body; that is, the statement executed when the ...To ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-format.html
In this case, you may have to run OPTIMIZE TABLE or myisamchk -r from time to time to improve performance. Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
Note Do not enable the WITH_TEST_TRACE_PLUGIN option if you want to use your own protocol trace plugins because only one such plugin can be loaded at a time and an error occurs for attempts to load a second one. Many options configure compile-time ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
The following procedure can be paused at any time and later resumed where it was, or reversed by jumping to the corresponding step of Section 16.1.4.3, “Disabling GTID Transactions Online”, the online procedure to disable GTIDs. To enable GTID ... This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous ...
https://dev.mysql.com/doc/refman/5.7/en/midpoint-insertion.html
If the block stays at the beginning of the sublist for a long enough time, it is demoted to the warm sublist. This time is determined by the value of the key_cache_age_threshold component of the key cache. The midpoint insertion strategy helps to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgmd.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...