Search Results
https://dev.mysql.com/doc/refman/9.7/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. There are also ways to obtain ...For a discussion of managing HASH and KEY partitions, see Section 26.3.2, “Management of HASH and KEY ...
https://dev.mysql.com/doc/refman/9.7/en/replica-logs-status.html
The connection metadata repository is written to the slave_master_info table in the mysql system schema, and the applier metadata repository is written to the slave_relay_log_info table in the mysql system schema. A warning message is issued if ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-capacity-options.html
--sleep=MS Command-Line Format --sleep=MS Type Numeric Default Value 0 Unit millisecond Specify the number in milliseconds to sleep after copying a certain amount of data from InnoDB tables. --skip-unused-pages Skip unused pages in tablespaces when ... These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource ...
https://dev.mysql.com/doc/refman/9.7/en/create-json-duality-view.html
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE}] [DEFINER = user] [SQL SECURITY {DEFINER | INVOKER}] JSON [RELATIONAL] DUALITY VIEW [IF NOT EXISTS] [schema_name.]view_name AS json_duality_select_statement json_duality_select_statement: SELECT ...Using OR REPLACE causes any existing JSON duality view of that name to be replaced by a new JSON duality view having the same ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. An expression default value for one column can refer to other table columns, with the exception that ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/9.7/en/alter-database.html
Encryption Option The ENCRYPTION option, defines the default database encryption, which is inherited by tables created in the database. The existing tables within it are part of the general mysql tablespace, which may be encrypted. All tables in the ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/9.7/en/hash-joins.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/9.7/en/storage-engines.html
Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
My-Comments For example: "\ha (HASHING) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- ha0ha.c Hashing/Hashing 8,145 Hash table with external chains Comments about hashing will be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
Enable MySQL Optimizer Trace If a query fails to offload and you cannot identify the reason, enable tracing and query the INFORMATION_SCHEMA.OPTIMIZER_TRACE table to debug the query. row *************************** id: 1 select_type: SIMPLE table: ... This topic describes how to debug queries that fail to offload to MySQL HeatWave for ...