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/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or ...To examine the source for the ARCHIVE engine, look in the storage/archive directory of a MySQL source ... The ARCHIVE storage ...
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
If the statement produces a result set, each column is converted to internal storage engine format that the FEDERATED engine expects and can use to display the result to the client that issued the original statement. A FEDERATED table consists of ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? A.1.5. Which version of MySQL is production-ready (GA)? MySQL 9.5, 8.4, and 8.0 are actively supported for production use. MySQL 8.0 achieved General Availability (GA) ...Does MySQL have a NOW() function with fractions of seconds? ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs.html
Updates to the replica's applier metadata repository table are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. For example, assuming that the data directory is located under ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transaction-inconsistencies.html
CHANGE MASTER TO statements for that channel fail with an error, unless the applier threads are running and the CHANGE MASTER TO statement only sets receiver options. Thus issuing RESET SLAVE on a replica with gaps means the replica loses any ...To ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”. Log files are located in the ...If you have problems starting the server, here are some things to try: Check the error log to see why the server does not ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
The following statement shows whether or not that transaction has been committed: SELECT GTID_SUBSET(LAST_SEEN_TRANSACTION, @@GLOBAL.GTID_EXECUTED) FROM performance_schema.replication_applier_status_by_worker; If the statement returns zero, the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
RECEIVED_TRANSACTION_SET The set of global transaction IDs (GTIDs) corresponding to all transactions received by this replica. Issuing RESET MASTER or RESET SLAVE resets the values shown in these columns. LAST_ERROR_TIMESTAMP A timestamp in YYMMDD ... This table shows the current status of the replication I/O thread that handles the replica's connection to the ...
https://dev.mysql.com/doc/refman/5.7/en/show-master-status.html
row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) When global transaction IDs are in use, ...