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/x-plugin-options-system-variables.html
mysqlx_connect_timeout Command-Line Format --mysqlx-connect-timeout=# Introduced 5.7.12 System Variable mysqlx_connect_timeout Scope Global Dynamic Yes Type Integer Default Value 30 Minimum Value 1 Maximum Value 1000000000 Unit seconds The number of ...If binding to the address fails, X Plugin produces an error and the server does not load ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Introduced 5.7.12 Type Enumeration Default Value ON Valid ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
A SET statement that assigns variable values is not written to the binary log, so in replication scenarios it affects only the host on which you execute it. To affect all replication hosts, execute the statement on each host. User-Defined Variable ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
The maximum number of condition areas in a diagnostics area is determined by the value of the max_error_count system variable. ERROR 1051 (42S02): Unknown table 'xx' Then execution enters the EXIT handler. ERROR 1051 (42S02): Unknown table 'xx' At ...RESIGNAL makes it possible to both handle an error and return the error ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
For additional detail about the properties of user names and host names as stored in the grant tables, such as maximum length, see Grant Table Scope Column Properties. MySQL account names consist of a user name and a host name, which enables ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
This number is incremented when a statement starts executing, not when it finishes. QUERIES_QUEUED The number of statements received that were queued for execution. This does not count statements that the thread group was able to begin executing ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transactions.html
However, when a second connection updates the nontransactional table before the first connection transaction is complete, statements can be logged out of order because the second connection update is written immediately after it is performed, ...In ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
DATETIME is packed more efficiently, requiring 5 rather than 8 bytes for the nonfractional part, and all three parts have a fractional part that requires from 0 to 3 bytes, depending on the fractional seconds precision of stored values. Fractional ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-subpartitions.html
Data and indexes belonging to p1's second subpartition (s1b) are stored on /disk5—the data in /disk5/data, and the indexes in /disk5/idx. Subpartitioning—also known as composite partitioning—is the further division of each partition in a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-status.html
When the replication SQL thread has caught up on I/O, Seconds_Behind_Master displays 0; but when the replication I/O thread is still queuing up a new event, Seconds_Behind_Master may show a large value until the SQL thread finishes executing the new ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...