Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
SQL_MODE The SQL mode in effect when the trigger was created, and under which the trigger executes. To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
That is, a SELECT that does not use a FOR UPDATE or LOCK IN SHARED MODE clause. Until updates or explicit locks are required, a transaction stays in read-only mode. InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
SELECT ON DUPLICATE KEY UPDATE statements are flagged as unsafe for statement-based replication. Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when ...
https://dev.mysql.com/doc/refman/8.4/en/insert-select.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
The directory should have a restrictive mode and be accessible only to the account used to run the MySQL server. Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_aws keyring plugin ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
For more information about batch mode, see Section 5.5, “Using mysql in Batch Mode”. The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-parallel-data-nodes.html
This means that all data nodes must run ndbmtd (ndbd is single-threaded and thus always has only one LDM) and they must be configured to use multiple LDMs before taking the backup; ndbmtd by default runs in single-threaded mode. It is possible to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-disk-data.html
Use of Disk Data tables is not supported when running the cluster in diskless mode. Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...