Search Results
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
To remove them, use the DROP FUNCTION statement: DROP FUNCTION service_get_read_locks; DROP FUNCTION service_get_write_locks; DROP FUNCTION service_release_locks; Using the Locking Service Function Interface Before using the locking service ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
ndb_import handles this in the same manner as a LOAD DATA statement does. --fields-enclosed-by=char Command-Line Format --fields-enclosed-by=char Type String Default Value [none] This works in the same way as the FIELDS ENCLOSED BY option does for ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-privileges.html
The SQL statements used to grant and revoke privileges on NDB tables, databases containing such tables, and columns within such tables are identical in all respects with the GRANT and REVOKE statements used in connection with database objects ... In ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. To change a table's ...There ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server automatically. The statement ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication continues. If a statement produces different errors on the source and the replica, the replication SQL thread ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-enable-gtids.html
On each server, execute the following statement: SET @@GLOBAL.enforce_gtid_consistency = WARN; Let the server run for a while with your normal workload and monitor the logs. On each server, execute this statement: SET ... This section describes how ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
If you cannot tell from the error log what the problem was, try the following techniques: Verify that the source has binary logging enabled by issuing a SHOW BINARY LOG STATUS statement. For example, --skip-replica-start prevents the replication ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Properly used, this prevents application users from entering values that cause the application to generate statements that have a different effect than you intend: MySQL SQL statements: Use SQL prepared statements and accept data values only by ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
An existing stored object can become orphaned through execution of a DROP USER statement that drops the object DEFINER account, or a RENAME USER statement that renames the object DEFINER account. (That is, the statement fails if dropping an account ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...