Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-tablespace.html
For an overview of Cluster Disk Data and data file characteristics, see CREATE TABLESPACE Statement, in the MySQL Manual. Tablespace Class Overview Tablespace Constructor Tablespace::getAutoGrowSpecification() Tablespace::getDefaultLogfileGroup() ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-17.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Prepared statement support was added to the C extension's (use_pure=False) implementation. (Bug #16562193, Bug #21072758, Bug #77003) Document fields containing arrays can now ...(Bug #27364973, Bug #21670979, Bug #77780, WL #12085) Added CONTRIBUTING.rst and replaced README.txt with ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...The CONNECTION string contains the information required to connect to the remote server containing the table in which the data physically ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
Serious corruption might cause SELECT * FROM tbl_name statements or InnoDB background operations to unexpectedly exit or assert, or even cause InnoDB roll-forward recovery to crash. Tries to make SELECT * FROM tbl_name jump over corrupt index ... To ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system variable. row ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-foreign-table.html
The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-purge-configuration.html
InnoDB does not physically remove a row from the database immediately when you delete it with an SQL statement. A row and its index records are only physically removed when InnoDB discards the undo log record written for the deletion. The InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; +--------------------+-----------------------------------------+ | Variable_name | Value | ... To ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-close.html
Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly. The counter works as follows: The first time a table is updated in MySQL, a counter in the header of the index files ...If you get the following warning from CHECK TABLE or myisamchk, it means that this counter has gone out of sync: clients are using or haven't closed the table properly This warning doesn't necessarily mean that the table is corrupted, but you should at least check the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dict-obj-tree.html
The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. This means that you must know ...