Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-temptables.html
In MySQL 8.4, when binlog_format is set to ROW or MIXED, statements that exclusively use temporary tables are not logged on the source, and therefore the temporary tables are not replicated. Statements that involve a mix of temporary and ...This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-formats.html
The correlation between binary logging formats and the terms used during replication are: When using statement-based binary logging, the source writes SQL statements to the binary log. Replication of the source to the replica works by executing the ... Replication works because events written to the binary log are read from the source and then processed on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-provision-replica.html
If you are using GTID-based replication, you need to pay attention to the SET @@GLOBAL.gtid_purged statement that mysqldump places in the dump output. This statement transfers the GTIDs for the transactions executed on the source to the replica, and ... If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-prepare.html
int mysql_stmt_prepare(MYSQL_STMT *stmt, const char *stmt_str, unsigned long length) Description Given the statement handler returned by mysql_stmt_init(), prepares the SQL statement pointed to by the string stmt_str and returns a status value. You ...However, they are not permitted for identifiers (such as table or column names), or to specify both operands of a binary operator such as the = equal ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-set-trace.html
MySQL Router supports tracing of statements as they are processed by MySQL Router from client to server and the response to the client. For example: [DEFAULT] max_idle_server_connections=64 [routing:{...}] client_ssl_mode=PREFERRED ...Configuration ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
This means that you can use the following SELECT statement to find rows into which invalid ENUM values were assigned: mysql> SELECT * FROM tbl_name WHERE enum_col=0; The index of the NULL value is NULL. and these potential issues to consider: If you ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
See Section 15.7.7.23, “SHOW INDEX Statement”, for more about this statement. What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem ...You have previously seen SHOW DATABASES, which lists the databases managed by the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
A FEDERATED table does not support indexes in the usual sense; because access to the table data is handled remotely, it is actually the remote table that makes use of indexes. This means that, for a query that cannot use any indexes and so requires ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... index_hint: { USE {INDEX|KEY} ...