PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. The log consists of a set of binary log files, plus an index file ...The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name or ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html
See Section 16.1.2.5.3, “Setting Up Replication between a New Source and Replicas” for how to proceed. Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for InnoDB tables. The source's binary log coordinates ... To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads.html
You can enable further parallelization for tasks on a replica by setting the slave_parallel_workers system variable to a value greater than 0 (the default). Note Multithreaded replicas are not currently supported by NDB Cluster, which silently ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the variables. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions.html
MySQL implements two sets of functions using function names defined by the OpenGIS specification. One set tests the relationship between two geometry values using precise object shapes, the other set uses object minimum bounding rectangles (MBRs).
https://dev.mysql.com/doc/refman/5.7/en/which-version.html
For example, distributions normally are compiled with support for all character sets. If you want a smaller MySQL server, you can recompile it with support for only the character sets you need. When preparing to install MySQL, decide which version ...First, decide whether to install a development release or a General Availability (GA) ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
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 ...