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/mysql-cluster-programs-ndb-select-all.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 ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
Based on whether the firewall accepts the statement, the server executes it or returns an error to the client. In DETECTING mode, the firewall permits the nonmatching statement to execute: mysql> SHOW TABLES LIKE 'customer%'; ...Grant the SUPER ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
Attempting to use an index key prefix length that exceeds the limit returns an error. ERROR 1070 (42000): Too many key parts specified; max 16 parts allowed The maximum row size, excluding any variable-length columns that are stored off-page, is ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
When the replication SQL thread executes an event read from the source, it modifies its own time to the event timestamp. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW PROCESSLIST, the number of seconds ...Must ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
rpl_semi_sync_master_timeout Command-Line Format --rpl-semi-sync-master-timeout=# System Variable rpl_semi_sync_master_timeout Scope Global Dynamic Yes Type Integer Default Value 10000 Minimum Value 0 Maximum Value 4294967295 Unit milliseconds A ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
A general event with the general_command.str field set to Query or Execute contains general_sql_command.str set to a value that specifies the type of SQL command: alter_db, alter_db_upgrade, admin_commands, and so forth. WHERE (for tables referenced ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
There are no plans at this time to introduce vertical partitioning into MySQL. In addition, MAX_ROWS and MIN_ROWS can be used to determine the maximum and minimum numbers of rows, respectively, that can be stored in each partition. This section ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-purge-configuration.html
The innodb_max_purge_lag_delay variable specifies the maximum delay in microseconds for the delay imposed when the innodb_max_purge_lag threshold is exceeded. When the purge lag exceeds the innodb_max_purge_lag threshold, a delay is imposed on ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. After an unexpected halt of a replica, upon restart the ...This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
The index TYPE value indicates the type of index (1 = Clustered Index, 0 = Secondary index). The CLUST_INDEX_SIZE and OTHER_INDEX_SIZE fields report the number of pages on disk that store clustered and secondary indexes for the table, respectively.