PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
You must check the replica's error log for error messages generated by the replication threads, or check that they are running satisfactorily with SHOW REPLICA STATUS. These options can still be used when the GTID_ONLY option was set on the CHANGE ...When you use these options, you must start the receiver thread (IO_THREAD option) or all the replication threads; you cannot start the replication applier thread (SQL_THREAD option) ...] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | MASTER_LOG_FILE = 'log_name', MASTER_LOG_POS = log_pos | SOURCE_LOG_FILE = 'log_name', SOURCE_LOG_POS = log_pos | RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos | SQL_AFTER_MTS_GAPS } ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. Otherwise, RESIGNAL is illegal and a RESIGNAL when handler not active error occurs. For example, the condition_value can be an SQLSTATE value, and the value can ...
https://dev.mysql.com/doc/refman/8.0/en/json-function-reference.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). MySQL also supports “pretty-printing” of JSON values in an easy-to-read format, using the JSON_PRETTY() function. For ... Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-event-tables.html
The difference between the two types of history tables relates to the data retention policy. Both tables contains the same data when an event is first seen. Because A and B together generate 101 events per second, the table contains data up to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. Values are also truncated to 6 decimal ...
https://dev.mysql.com/doc/refman/8.0/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. For general discussion of the authentication process, see Section 8.2.17, “Pluggable ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was away. To enable this method of state transfer, you must install the clone plugin ...The joining member begins by checking the relay log for its group_replication_applier channel for any transactions that it already received from the group but did not yet ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-first-start.html
Each cluster node process must be started separately, and on the host where it resides. Note The IP address shown for a given NDB Cluster SQL or other API node in the output of SHOW is the address used by the SQL or API node to connect to the ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). The disadvantage of this is that you must ensure that your statements always refer to your database and ... In MySQL, databases correspond to directories within the data ...One notable exception is macOS, which is Unix-based ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
PARTITION BY statement must follow the same rules as one created using CREATE TABLE ... Any data that was stored in the dropped partitions named in the partition_names list is discarded. TABLESPACE options extend the Transportable Tablespace feature ...Simply using a partition_options clause with ALTER TABLE on a partitioned table repartitions the table according to the partitioning scheme defined by the ... Partitioning-related clauses for ALTER ...