PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-installation.html
For general information about installing or uninstalling plugins and loadable functions, see Section 5.5.1, “Installing and Uninstalling Plugins”, and Section 5.6.1, “Installing and Uninstalling Loadable Functions”. If necessary, configure ...To avoid this overhead, do not install it unless you plan to use ...
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, ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. They provide alternative ways to perform operations that would otherwise require complex joins and unions. A ...Here ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
CEILING(3.7004397181411) is 4, and V = POWER(2,4), which is 16.) Set N = F(column_list) & (V - 1). MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas ...
https://dev.mysql.com/doc/refman/5.7/en/repeat.html
For the rules regarding label use, see Section 13.6.2, “Statement Labels”. [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
This can be used, for example, to create a shorter name by which to refer to a schema with a long name (such as info rather than INFORMATION_SCHEMA). Parameters in_db_name VARCHAR(64): The name of the schema for which to create the synonym. Given a ...
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 ...