Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
The REQUIRE_TABLE_PRIMARY_KEY_CHECK option makes the replication channel use its own policy for primary key checks. When PRIVILEGE_CHECKS_USER is set, setting REQUIRE_TABLE_PRIMARY_KEY_CHECK to either ON or OFF means that the user account does not ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules.html
You should not use these options to control which databases and tables are replicated. If no database-level options are used, option checking proceeds to any table-level options that may be in use (see Section 19.2.5.2, “Evaluation of Table-Level ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the record in question and does not require you to reload the table. If a table contains invisible ...
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
row *************************** Engine: MEMORY Support: YES Comment: Hash based, stored in memory, useful for temporary tables Transactions: NO XA: NO Savepoints: NO *************************** 2. row *************************** Engine: MRG_MYISAM ... SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Without SIGNAL, it is necessary to resort to workarounds such as deliberately referring to a nonexistent table to cause a routine to return an error. The following statements cause that error because the named condition is associated with a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
CMake Option Reference General Options Installation Layout Options Storage Engine Options Feature Options Compiler Flags CMake Options for Compiling NDB Cluster CMake Option Reference The following table shows the available CMake options. If it is ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
When the source is using the row-based binary logging format, you should execute STOP REPLICA or STOP REPLICA SQL_THREAD on the replica prior to shutting down the replica server if you are replicating any tables that use a nontransactional storage ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
MySQL recognizes the escape sequences shown in Table 11.1, “Special Character Escape Sequences”. For the escape sequences that represent each of these characters, see Table 11.1, “Special Character Escape Sequences”. A string is a sequence ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links.html
You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...The recommended way to do this is to symlink entire database directories to a different ...