Search Results
https://dev.mysql.com/doc/internals/en/tracing-example.html
"rest_of_plan": [ { "database": "test", "table": "alias2", "best_access_path": { "considered_access_paths": [ { "access_type": "ref", "index": "PRIMARY", "records": 1, "cost": 20.2, "chosen": true We choose ref access on the primary key of alias2.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-blob-tool.html
This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...These options cause ndb_blob_tool to check for orphaned BLOB parts, remove any orphaned BLOB parts, and generate a dump file listing orphaned BLOB parts, respectively, and are described in more detail later in this ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates the table definition in the global data dictionary. The setup for the source is: CREATE TABLE t1 (public_col_1, ..., public_col_N, secret_col_1, ..., secret_col_M) ENGINE=MyISAM; The setup for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
However, FOR SHARE supports OF table_name, NOWAIT, and SKIP LOCKED options. FOR SHARE statements do not acquire read locks on MySQL grant tables. FOR UPDATE requires the SELECT privilege and at least one of the DELETE, LOCK TABLES, or UPDATE ... If ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
Queries using JSON_CONTAINS() on InnoDB tables can be optimized using multi-valued indexes; see Multi-Valued Indexes, for more information. row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range ... The ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). This type of backup is suitable for smaller amounts of data where you ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
If you create a MyISAM table and insert only one or two rows of text into it, every word in the text occurs in at least 50% of the rows. For each row in the table, MATCH() returns a relevance value; that is, a similarity measure between the search ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-mysql-configuration-details.html
Table 19-2 MySQL Configuration Summary Details Field Description State The state of the configuration: ACTIVE: The configuration was successfully created and is ready to be used. Click the name of the configuration to open the Table 19-1 for the ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
When you create an ARCHIVE table, the storage engine creates files with names that begin with the table name. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES table. If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table ...Check if you have the SELECT and INSERT privileges for the table that you want to ...