Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates for EXPLAIN queries. Runtime estimates for queries that fail due to an out-of-memory error. Runtime data can be used for query optimization, ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-jdbc-url-format.html
This section explains the syntax of the URLs for connecting to MySQL. This is the generic format of the connection URL: protocol//[hosts][/database][?properties] The URL consists of the following parts: Important Any reserved characters for URLs ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-clusterjtableexception.html
ClusterJTableException also provides methods for reporting the name of the table used in the search, and the elapsed time spent attempting to get the table. ClusterJTableException is used for reporting all "Table Not Found" conditions in Cluster/J.
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-jdbc-url-format.html
This section explains the syntax of the URLs for connecting to MySQL. This is the generic format of the connection URL: protocol//[hosts][/database][?properties] The URL consists of the following parts: Important Any reserved characters for URLs ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
You can configure InnoDB buffer pool size offline or while the server is running. For additional information about configuring buffer pool size online, see Configuring InnoDB Buffer Pool Size Online. When increasing or decreasing ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. SMALLINT SMALLINT BIGINT BIGINT ...
https://dev.mysql.com/doc/internals/en/error-messages-5-0-3-higher.html
The file you edit to add a new error message depends on your version of MySQL: MySQL 5.0.3 up to 5.5: Edit errmsg.txt MySQL 5.5 and up: Edit errmsg-utf8.txt In either case, comp_err generates the header files automatically during the MySQL build ...