PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-select.html
If the destination table does not exist, logging occurs as follows. ROW format: The statement is logged as a CREATE TABLE statement followed by a series of insert-row events. Prior to MySQL 8.0.21, the statement is logged as two transactions. For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql schema are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-repair-table.html
When used on a corrupted or otherwise damaged table, it is possible for the REPAIR TABLE statement to delete rows that cannot be recovered. However, any such modifications of table data performed by this statement are not replicated, which can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-sql-mode.html
At a minimum, this is likely to cause the distribution of data among partitions to be different in the source's and replica's copies of a given table. Using different server SQL mode settings on the source and the replica may cause the same INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the sources using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication applier metadata repositories, and provisioned the replica with data ...Use the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...
https://dev.mysql.com/doc/refman/8.0/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. The LIKE clause, if present, indicates which database names to match. You see only those databases for which you have some kind of ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The guidelines cover SQL operations that read and write data, the ...The ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html
This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. Metadata changes to objects referred to by stored programs are detected and cause automatic reparsing of the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-check-lost-instrumentation.html
This view returns information about lost Performance Schema instruments, to indicate whether the Performance Schema is unable to monitor all runtime data. The ps_check_lost_instrumentation view has these columns: variable_name The Performance ...
https://dev.mysql.com/doc/refman/8.0/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. Use mysqlshow to see what databases exist: $> bin/mysqlshow +--------------------+ | Databases | ...This ...That enables your shell (command interpreter) to find MySQL programs properly, so that you can run a program by typing only its name, not its path ...