Search Results
https://dev.mysql.com/doc/refman/9.7/en/online-ddl-memory-management.html
Online DDL operations that create or rebuild secondary indexes allocate temporary buffers during different phases of index creation. The setting applies to buffers created by threads executing online DDL operations. Defining an appropriate buffer ...The innodb_ddl_buffer_size variable defines the maximum buffer size for online DDL ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-supported-components.html
To be shown in the mysql_option.option_usage and mysql_option tables, a component or plugin must be written and compiled with support for the Option Tracker. The name of the Option Tracker status variable (usage counter) associated with this ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-float.html
Suppose that you execute the following statements: CREATE TABLE t1(c1 FLOAT(53,0), c2 FLOAT(53,0)); INSERT INTO t1 VALUES('1e+52','-1e+52'); SELECT * FROM t1; On some platforms, the SELECT statement returns inf and -inf. An implication of the ...
https://dev.mysql.com/doc/refman/9.7/en/programs-overview.html
mysqladmin A client that performs administrative operations, such as creating or dropping databases, reloading the grant tables, flushing tables to disk, and reopening log files. Oracle Corporation also provides the MySQL Workbench GUI tool, which ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/9.7/en/rebuilding-tables.html
If you need to rebuild an InnoDB table because a CHECK TABLE operation indicates that a table upgrade is required, use mysqldump to create a dump file and mysql to reload the file. For example, if t1 is an InnoDB table, use this statement: ALTER ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-load-data.html
If you use LOAD DATA with binlog_format=STATEMENT, each replica on which the changes are to be applied creates a temporary file containing the data. This temporary file is not encrypted, even if binary log encryption is active on the source, If ...
https://dev.mysql.com/doc/refman/9.7/en/replication-threads.html
The source creates a thread to send the binary log contents to a replica when the replica connects. When a START REPLICA statement is issued on a replica server, the replica creates an I/O (receiver) thread, which connects to the source and asks it ... MySQL replication capabilities are implemented using the following types of threads: Binary log dump ...