Search Results
https://dev.mysql.com/doc/refman/8.4/en/online-ddl-memory-management.html
Defining an appropriate buffer size limit avoids potential out of memory errors for online DDL operations that create or rebuild secondary indexes. Online DDL operations that create or rebuild secondary indexes allocate temporary buffers during ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
The use of CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP or NOW() as a default value for a timestamp column. Enable explicit_defaults_for_timestamp to use ALTER TABLE and CREATE TABLE statements with Lakehouse tables that have a timestamp column. A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-redo-log-reader.html
Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or both. Command-Line Format -mbyte # Type Numeric Default Value 0 Minimum Value 0 Maximum Value 15 -mbyte #: Starting megabyte. Command-Line Format ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
If you are using this option to repair tables, it runs an extended repair that may not only take a long time to execute, but may produce a lot of garbage rows also! --default-auth=plugin Command-Line Format --default-auth=plugin Type String A hint ...If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples-compression-sect.html
Compressing or uncompressing pages has consumed less than a second since the time the statistics were reset, because the columns COMPRESS_TIME and UNCOMPRESS_TIME are zero. This copying of SUM(PAGE_SIZE*RELOCATION_OPS) bytes has consumed less than a ... Example 17.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 17.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-timestamp2.html
The file timestamp2.cpp reproduced in this section provides an example of working in NDB API applications with the “new” MySQL temporal data types supporting fractional seconds. For more information working with MySQL temporal and other data ...
https://dev.mysql.com/doc/internals/en/select-select-engine.html
If this is the first time, call JOIN::optimize and JOIN::exec(), else do nothing or JOIN::reinit()JOIN::exec() depending on type of subquery. subselect_single_select_engine: constructor allocate JOIN and store pointers on SELECT_LEX and JOIN.
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
If you have multiple source trees at the same level (for example, to build multiple versions of MySQL), the second strategy can be advantageous. With the second strategy, you can use the same name for the build directory within each source tree. To ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
This enables the external user to be a proxy for the second user; that is, to assume the privileges of the second user: The external user is a “proxy user” (a user who can impersonate or become known as another user). The second user is a ...The ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
This value is defined by the MySqlTraceEventType public enum contained in the Connector/NET code: public enum MySqlTraceEventType : int { ConnectionOpened = 1, ConnectionClosed, QueryOpened, ResultOpened, ResultClosed, QueryClosed, ...Trace switches ... The .NET tracing architecture consists of four main parts: Source - This is the originator of the trace ...