Search Results
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
Let S be a logged statement that does not have an implicit commit, except CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT, UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA INFILE, and BINLOG. It also ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-index.html
Usage ndb_drop_index -c connection_string table_name index -d db_name The statement shown above drops the index named index from the table in the database. Options that can be used with ndb_drop_index are shown in the following table. --database, -d ...It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for ...
https://dev.mysql.com/doc/refman/8.4/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
If the issue persists, reload the table and retry the query with use_secondary_engine session variable set to FORCED. Error number: 1010; Symbol: HW_ER_SUBQUERY_TRANSFORM Message: The subquery, [%s], cannot be transformed into a semi-join, anti-join ... The following list contains all current MySQL HeatWave errors in numerical ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
Even with additional write costs, secondary indexes on virtual columns may be preferable to generated stored columns, which are materialized in the clustered index, resulting in larger tables that require more disk space and memory. row ...A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-server-operations.html
The server_operations table contains entries for all ongoing NDB operations that the current SQL node (MySQL Server) is currently involved in. It effectively is a subset of the cluster_operations table, in which operations for other SQL and API ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. Use joins wherever data is pulled from multiple tables based on identical ID values from those ...Adding foreign keys ensures that referenced columns are indexed, which can improve ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-blobs.html
Parts of JSON values exceeding 4000 bytes in size are also stored in this table. The part and inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column comments (see NDB_COLUMN Options); ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. The reorganized tables require less disk ...This is a straightforward technique that can improve performance when other techniques such as improving index usage or tuning application code are not ...