Search Results
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
No usable indexes were found for the table, which forces the optimizer to search every row. The visual explain feature generates and displays a visual representation of the MySQL EXPLAIN statement by using extended information available in the ...
https://dev.mysql.com/doc/internals/en/myisam-files.html
Some notes about MyISAM file handling: If a table is never updated, MySQL will never touch the table files, so it would never be marked as closed or corrupted. If a table is marked readonly by the OS, it will only be opened in readonly mode. When a ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-columnmetadata.html
Table 4.17 charsetName() Parameter Description return the charset name 4.3.1.11.2 columnType() public abstract ColumnType columnType(); Return the type of the column. Table 4.18 columnType() Parameter Description return the type of the column ...
MySQL NDB Cluster API Developer Guide :: 4.2.2.5 ClusterJ Mappings Between MySQL and Java Data Types
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-mappings.html
Note Since Java does not have native unsigned data types, UNSIGNED columns should be avoided in table schemas if possible. The following tables show the mappings used by ClusterJ between common Java data types and MySQL column types. The following ... ClusterJ provides mappings for all of the common MySQL database types to Java ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-dmlstatementactivity-category.html
Table 8.4 DML Statement Activity Metrics NameDescriptionTarget Name Name of the OEM Target Call Procedure (Delta) The total number of CALL statements executed. Delete Multi (Delta) The total number of multi-table DELETE statements executed. Lock ...
https://dev.mysql.com/doc/heatwave/en/heatwave-status-variables.html
ON: Indicates that change propagation is enabled globally, permitting changes to InnoDB tables on the MySQL DB System to be propagated to their counterpart tables in the MySQL HeatWave Cluster. initializing: The event-based incremental load feature ...Data is tracked in megabytes and is a cumulative total of data scanned since the MySQL HeatWave Cluster was last ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
For Advisor to provide string column encoding recommendations, tables must be loaded in MySQL HeatWave and a query history must be available. (The default group_concat_max_len setting is 1024 bytes.) mysql> SET SESSION group_concat_max_len = ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-27-u2.html
(WL #14752) The rpd_query_stats table, which stores MySQL HeatWave query history (compilation and execution statistics), now stores data for the last 1000 executed queries. The following columns were added to the performance_schema.rpd_tables table: ... Functionality Added or Changed MySQL HeatWave now supports querying ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-30.html
(Bug #34145862) MySQL HeatWave AutoML You can now train MySQL HeatWave AutoML models on tables containing DATE, TIME, DATETIME, TIMESTAMP, and YEAR data types. The following columns were added to the MODEL_CATALOG table: column_names: The feature ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table tbl_name. This statement is mapped to an ALTER TABLE statement to drop ...This is done automatically by the server whenever it determines that it is possible to do so; you do not have to use any special SQL syntax or server options to cause it to ...