Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/option-tracker-component-functions.html
The Option Tracker provides the functions shown in the next table. More detailed information about each function is provided in the list following the table. These functions provide safe interfaces for reading and updating the ...Syntax: int ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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.7/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/internals/en/implementing-info-method.html
Prior to commencing a table scan, the [custom-engine.html#custom-engine-api-reference-info info()] method is called to provide extra table information to the optimizer. The stats member is an instance of the ha_statistics class which is also ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
Load this data into MySQL HeatWave as an aggregate table by using Auto Parallel Load. Update this table with new data loaded to the same bucket for new aggregates by using the incremental load feature. Therefore, instead of having queries compute ...