MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 951 to 960 of 1164 total results

19.1.2.4 Obtaining the Replication Source Binary Log Coordinates

https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html

row *************************** File: mysql-bin.000003 Position: 73 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) The File column shows the name of the log file ... 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 ...

Chapter 19 Replication

https://dev.mysql.com/doc/refman/8.0/en/replication.html

There are two core types of replication format, Statement Based Replication (SBR), which replicates entire SQL statements, and Row Based Replication (RBR), which replicates only the changed rows. You can use replication to solve a number of ...

5.3.4.3 Selecting Particular Columns

https://dev.mysql.com/doc/refman/8.0/en/selecting-columns.html

If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.

15.7.7.9 SHOW CREATE PROCEDURE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html

row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...

15.7.7.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html

row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...

15.7.7.23 SHOW MASTER STATUS Statement

https://dev.mysql.com/doc/refman/8.0/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, ...

15.7.7.33 SHOW REPLICAS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-replicas.html

This is the server ID of the server on which SHOW REPLICAS is executed, so this same value is listed for each row in the result. {SHOW REPLICAS} Displays a list of replicas currently registered with the source. From MySQL 8.0.22, use SHOW REPLICAS ...

15.7.7.37 SHOW STATUS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-status.html

A WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] SHOW STATUS provides server status information ...

14.16.12 Spatial Aggregate Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html

The result is the narrowest MultiXxx or GeometryCollection value possible, with the result type determined from the non-NULL geometry arguments as follows: If all arguments are Point values, the result is a MultiPoint value. MySQL supports ...

30.4.3.3 The host_summary_by_file_io_type and x$host_summary_by_file_io_type Views

https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io-type.html

By default, rows are sorted by host and descending total I/O latency. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These ...

Displaying 951 to 960 of 1164 total results