Search Results
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...The goal of the query optimizer is to find an optimal QEP among all such possible ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API application. The source code can be found can be found in the file ...
https://dev.mysql.com/doc/x-devapi-userguide/en/sql-crud-functions.html
Table.insert() The Table.insert() method works like an INSERT statement in SQL. It is used to store data in a relational table in the database. The example assumes that the test schema exists and is assigned to the variable db, and that an empty ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload-syntax.html
This adds an include list to exactly specify the tables to unload, which eliminates the need to include a database and exclude unnecessary tables. mysql> CALL sys.HEATWAVE_UNLOAD_all (options); options: {JSON_OBJECT(keyvalue[, keyvalue]...)|NULL} ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
Prepare Data Before loading data, ensure that you meet the following requirements: The tables you intend to load must be set to ENGINE=InnoDB tables. You can manually convert tables by using the following ALTER TABLE statement: mysql> ALTER TABLE ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-loading-unloading-heatwave.html
You can view the following information about schemas and tables: Name: The name of the schema or table. Memory Size Estimate (GiB): An estimate of the memory required on the MySQL HeatWave Cluster for the schema or table. String Column Encoding: The ... Loading or Unloading Data into MySQL HeatWave Cluster 9.1 Loading or Unloading Data into MySQL HeatWave Cluster Use MySQL HeatWave Console to load data into or unload data from a MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. The SQL statements used to grant and revoke privileges on NDB tables, databases containing ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-lifecycle.html
Whenever the binary log is rotated or the server is shut down, the server writes GTIDs for all transactions that were written into the previous binary log file into the mysql.gtid_executed table. With binary logging enabled (as required for the ...
https://dev.mysql.com/doc/refman/9.7/en/where-optimization.html
COUNT(*) on a single table without a WHERE is retrieved directly from the table information for MyISAM and MEMORY tables. This is also done for any NOT NULL expression when used with only one table. For each table in a join, a simpler WHERE is ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
With non-transactional tables such as MyISAM, locks are placed on entire partitioned table. Suppose that we have a partitioned table with N columns, using partitioning type p_type and the partitioning function p_func, represented like this: CREATE ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...