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/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. This section provides a conceptual overview of partitioning in MySQL 5.7. For ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
The PARTITIONS table in the INFORMATION_SCHEMA database provides information about partitions and partitioned tables. See Section 24.3.16, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some examples of queries against this ...Note As of MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is removed in MySQL 8.0, when the storage engine used for a given table is expected to provide its own (“native”) partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
Oracle Corporation also provides the MySQL Workbench GUI tool, which is used to administer MySQL servers and databases, to create, execute, and evaluate queries, and to migrate schemas and data from other relational database management systems for ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
If a table has triggers, attempts to rename the table into a different database fail with a Trigger in wrong schema (ER_TRG_IN_WRONG_SCHEMA) error. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-reserved-words.html
You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the replica. An example of this is using a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-auto-positioning.html
This GTID set is equal to the union of the set of GTIDs in the gtid_executed system variable (@@GLOBAL.gtid_executed), and the set of GTIDs recorded in the Performance Schema replication_connection_status table as received transactions (the result ... GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
The GTID for a transaction is shown in the output from mysqlbinlog, and it is used to identify an individual transaction in the Performance Schema replication status tables, for example, replication_applier_status_by_worker. This thread is not ... A ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
The function can return the union of gtid_executed on each replica with the set of transactions received by the replica, which is recorded in the Performance Schema replication_connection_status table. On each replica, compute the complete record of ... This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
Using SELECT @@ENFORCE_GTID_CONSISTENCY, SHOW VARIABLES LIKE 'ENFORCE_GTID_CONSISTENCY', and SELECT * FROM INFORMATION_SCHEMA.VARIABLES WHERE 'VARIABLE_NAME' = 'ENFORCE_GTID_CONSISTENCY', all return the textual form, not the numeric form. This is an ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads respectively. For a ...