Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl.html
The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for ...For in-place operations, the ability to adjust the balance between performance and concurrency during DDL operations using the LOCK ...
https://dev.mysql.com/doc/refman/8.4/en/kill.html
Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads table. ALTER TABLE operations ... KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
If you invoke mysqldump with the --tab=dir_name option, it uses dir_name as the output directory and dumps tables individually in that directory using two files for each table. For a table named t1, the files are named t1.sql and t1.txt. The .sql ...
https://dev.mysql.com/doc/refman/8.4/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...If ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
The Information Schema RESOURCE_GROUPS table exposes information about resource group definitions and the Performance Schema threads table shows the resource group assignment for each thread. Resource group names are identifiers like table and ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysqlsh.html
This authentication type is only suitable for a secure connection that uses SSL or sockets, so you must configure the secure connection before using it. --connect-timeout=ms Configures how long MySQL Shell waits (in milliseconds) to establish a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-data-drift-detection.html
You can monitor data drift in the model catalog and when running the ML_PREDICT_ROW and ML_PREDICT_TABLE routines. For the ML_PREDICT_ROW and ML_PREDICT_TABLE routines, the options parameter includes the additional_details boolean value. Run the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-cluster-log.html
The following table lists the most common NDB cluster log messages. Table 25.25 Common NDB cluster log messages Log Message Description Event Name Event Type Priority Severity Node mgm_node_id: Node data_node_id Connected The data node having node ...For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
Additionally, several places in the server call the audit interface when an auditable event occurs, so that registered audit plugins can be notified about the event if necessary. When the plugin is enabled, these variables can be inspected using ...