Search Results
https://dev.mysql.com/doc/internals/en/com-register-slave.html
Fields server_id (4) -- the slaves server-id slave_hostname (string.var_len) -- see report_host, usually empty slave_user (string.var_len) -- see report_user, usually empty slave_password (string.var_len) -- see report_password, usually empty ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #37597512, Bug #37569333) The fprintf_string() function in mysqldump did not use the actual quote character for string escaping. As of this release, long strings, such as filenames and demangled functions, are written directly to the output.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/8.4/en/lock-order-tool.html
lock_order_dependencies Command-Line Format --lock-order-dependencies=file_name System Variable lock_order_dependencies Scope Global Dynamic No SET_VAR Hint Applies No Type File name Default Value empty string The path to the ... The MySQL server is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-sql-statements.html
row *************************** PLUGIN_NAME: ndbcluster PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 80406.0 PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL PLUGIN_AUTHOR: Oracle Corporation ... This ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
This means that, using the default values for this option and for SOURCE_CONNECT_RETRY (60), the replica waits 60 seconds between reconnection attempts, and keeps attempting to reconnect at this rate for 10 minutes before timing out and failing over. The new GTID format is UUID:TAG:NUMBER, where TAG is a string of up to 8 characters, which is enabled by setting the value of the gtid_next system variable to AUTOMATIC:TAG, added in this release (see the description of the variable for tag format and other ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those characteristics that all operands have: a data type, a length, an indication that it can be ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexscanoperation.html
Members Member names, types, and descriptions are shown in the following table: Table 2.47 IndexBound structure member names, types, and descriptions Name Type Description low_key const char* Row containing lower bound for scan (or NULL for scan ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
Invisible columns support the usual column attributes: NULL, NOT NULL, AUTO_INCREMENT, and so forth. row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `col1` int DEFAULT NULL, `col2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...