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/binary-log-mixed.html
A warning is added to the SHOW WARNINGS table each time such a statement is executed. Type binlog_format SLC RLC Error / Warning Logged as * * No No Error: Cannot execute statement: Binary logging is impossible since at least one engine is involved ...If a statement is logged by row and the session that executed the statement has any temporary tables, logging by row is used for all subsequent statements (except for those accessing temporary tables) until all temporary tables in use by that session are ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
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/optimizing-innodb-diskio.html
Executables or libraries must not be placed on a direct I/O file system. (Measure at a time when the server is not doing bulk inserts; it is normal during bulk inserts for the modified pages percentage to rise significantly.) Log sequence number - ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
The following parameters apply to the config.ini file's [tcp] section: Checksum: If checksum is enabled, all signals between nodes are checked for errors. HostName2: Name or IP address of second of two computers joined by TCP connection. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). total_latency The total wait time of timed I/O events for the table. fetch_latency The total wait time of timed read I/O events for the table. The ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Strict mode produces an error for attempts to create a key that exceeds the maximum key length. If the statement inserts or modifies multiple rows and the bad value occurs in the second or later row, the result depends on which strict mode is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
This section describes these checks, how you can control them, and error and warning conditions that might arise. The .frm files are created and managed by MySQL, and can sometimes get out of sync with the internal metadata in InnoDB. InnoDB ...
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 ...