Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
For this reason, replication of such a statement may not be safe when STATEMENT mode is in use. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes ...In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-locking.html
This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() method. Sets a shared mode lock on any rows that are read. LOCK IN SHARE ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-locking.html
This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() method. Sets a shared mode lock on any rows that are read. LOCK IN SHARE ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-locking.html
This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() method. Sets a shared mode lock on any rows that are read. LOCK IN SHARE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
Row number and character position details are added to warning messages(Non strict mode) in csv and JSON file formats. Row number is added to warning messages(Non strict mode) in parquet or AVRO file formats. For example: mysql> SET ... See MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
This type of repair is like that done by myisamchk --safe-recover. Caution Use the USE_FRM option only if you cannot use regular REPAIR modes. For a MyISAM table, if you do not get OK, you should try repairing it with myisamchk --safe-recover. With ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. The safe way to restart a replica that is replicating MEMORY ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-replication-standard-rules.html
You can also cause the server to write checksums for the events using CRC32 checksums by setting the binlog_checksum system variable, to add an extra level of safety to the logs and the replication process. Source Not Verifying Checksums When ...By ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
You can also cause the server to write checksums for the events using CRC32 checksums by setting the binlog_checksum system variable, to add an extra level of safety to the logs and the replication process. You can also cause the server to write ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
With auto-reconnect disabled, if the connection drops, an error occurs for the next statement issued. Interaction of Table Locking and Transactions LOCK TABLES and UNLOCK TABLES interact with the use of transactions as follows: LOCK TABLES is not ...