Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
If any characteristics apply that cannot be passed to START TRANSACTION, such as ISOLATION LEVEL, a suitable SET TRANSACTION statement is prepended (for example, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; START TRANSACTION READ WRITE;). If a ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/internals/en/implementing-rnd-next-method.html
In each format, the columns appear in the order in which they were defined by the CREATE TABLE statement. After the table is initialized, the MySQL server will call the handler's [custom-engine.html#custom-engine-api-reference-rnd_next rnd_next()] ...The rnd_next() method takes a single byte array parameter named ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
An example of such a query, using the table t1 created previously, is shown here: mysql> EXPLAIN -> SELECT * FROM t1 AS x -> LEFT JOIN t1 AS y -> ON x.a=0 AND y.b>=3\G *************************** 1. Joins are not directly supported; conditions ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ...A single-row subquery from a table or tables is not considered a ... When an operator is used with operands of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-parallel-load-overview.html
mysql> GRANT SELECT ON performance_schema.* TO 'user_name'@'%'; About Lakehouse Auto Parallel Load Schema Inference Lakehouse Auto Parallel Load includes schema inference, and uses it in one of two ways: Lakehouse Auto Parallel Load analyzes the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
This reflects the creation of the hidden primary key that is a feature of all tables using the NDB storage engine. Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned ... A number of types of statistical counters relating to actions performed by or affecting Ndb objects are ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-prerequisites.html
If you try to create a table without a primary key in a high availability DB system, it will fail. Using sql_generate_invisible_primary_key variable: Set the variable to ON to add primary keys to new tables that you create. Prerequisites 12.2 ...A ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
With an innodb_force_recovery value of 3 or less you can DROP or CREATE tables. To investigate database page corruption, you might dump your tables from the database with SELECT ... In such cases, you can use the innodb_force_recovery option to ...
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT statements. It does not use the cache for TCP connections established using a loopback interface address (for example, 127.0.0.1 ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...