Search Results
https://dev.mysql.com/doc/refman/8.4/en/controlling-optimizer.html
MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the optimizer cost model. The server maintains histogram statistics about column values in ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query-ordering.html
Ordering 4.3.1.20.1 Synopsis public static final class Query.Ordering extends, Enum<Ordering> {// Public Static Fields public static final Ordering ASCENDING ; public static final Ordering DESCENDING ;// Public Static Methods public static Ordering ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-quan-pages.html
This chapter describes the Query Analyzer and Memory Usage pages.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-load-progress.html
The time required to load a table into MySQL HeatWave depends on data size. mysql> SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME = 'rapid_load_progress'; +----------------+ | VARIABLE_VALUE | +----------------+ | ...You can monitor load progress by issuing the following query, which returns a percentage value indicating load ...
https://dev.mysql.com/doc/refman/8.4/en/estimating-performance.html
In MySQL, an index block is usually 1,024 bytes and the data pointer is usually four bytes. As long as everything is cached by the OS or the MySQL server, things become only marginally slower as the table gets bigger. In most cases, you can ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-optimizer.html
It is possible for the data on the source and replica to become different if a statement is written in such a way that the data modification is nondeterministic; that is, left up the query optimizer. (In general, this is not a good practice, even ...
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/internals/en/begin-load-query-event.html
Binlog::BEGIN_LOAD_QUERY_EVENT: truncate a file and set block-data Payload 4 file_id string.EOF block-data See Binlog::APPEND_BLOCK_EVENT .
https://dev.mysql.com/doc/internals/en/execute-load-query-event.html
Binlog::EXECUTE_LOAD_QUERY_EVENT: Post-header 4 slave_proxy_id 4 execution time 1 schema length 2 error-code 2 status-vars length Payload 4 file_id 4 start_pos 4 end_pos 1 dup_handling_flags See Binlog::QUERY_EVENT .
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-query-predicate.html
4.3.3.1.1 Synopsis public interface Predicate {// Public Methods public abstract Predicate and(Predicate predicate); public abstract Predicate not(); public abstract Predicate or(Predicate predicate);} 4.3.3.1.2 and(Predicate) public abstract ...