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-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
If you use any of those statements but specify an xid value that does not correspond to some existing XA transaction, an error occurs. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
After using this value, be prepared to drop and recreate all secondary indexes. To investigate database page corruption, you might dump your tables from the database with SELECT ... Usually, most of the data obtained in this way is intact. Serious ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.
https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html
You can use the following methods to speed up inserts: If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is considerably faster (many times ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent I/O error took place. replication_connection_status Column SHOW SLAVE STATUS Column SOURCE_UUID Master_UUID THREAD_ID None SERVICE_STATE Slave_IO_Running ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-detection.html
Resolve these situations by setting the value of the innodb_lock_wait_timeout system variable. A wait-for list that exceeds 200 transactions is treated as a deadlock and the transaction attempting to check the wait-for list is rolled back. The same ... When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the ...
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 ...