No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/innodb-indexes-table.html
0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. For ...
https://dev.mysql.com/memory-storage-engine.html
Support for variable-length data types (including BLOB and TEXT) not supported by MEMORY. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to ...
https://dev.mysql.com/mysql-cluster-limitations-syntax.html
You cannot create indexes on NDB table columns that use any of the TEXT or BLOB data types. The NDB storage engine does not support FULLTEXT indexes, which are possible for MyISAM and InnoDB tables only. As of NDB 8.0.16: ON DELETE CASCADE is not ...
https://dev.mysql.com/mysql-cluster-ndbinfo-memoryusage.html
used_pages integer Number of pages currently used for data memory or index memory by this data node; see text. total integer Total number of bytes of data memory or index memory available for this data node; see text. total_pages integer Total ...
https://dev.mysql.com/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. You can find more detailed ...
https://dev.mysql.com/mysql-cluster-programs-ndb-config.html
The dump can be produced in either text or XML format; for more information, see the discussion of the --configinfo and --xml options later in this section). All NDB 8.0 releases --configinfo Dumps information about all NDB configuration parameters ... This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an NDB Cluster management node, or its config.ini or my.cnf ...
https://dev.mysql.com/mysql-cluster-programs-ndb-desc.html
All NDB 8.0 releases --unqualified, -u Use unqualified table names All NDB 8.0 releases --blob-info, -b Include information about subordinate BLOB and TEXT columns. ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc ...
https://dev.mysql.com/mysql-cluster-replication-conflict-resolution.html
Note If you are replicating tables with very large columns (such as TEXT or BLOB columns), --ndb-log-updated-only can also be useful for reducing the size of the master and slave binary logs and avoiding possible replication failures due to ... When ...
https://dev.mysql.com/optimize-numeric.html
If you are using numeric data, it is faster in many cases to access information from a database (using a live connection) than to access a text file. Information in the database is likely to be stored in a more compact format than in the text file, ... For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string ...
https://dev.mysql.com/performance-schema-statement-tables.html
SQL statements are expressed as text, such as DELETE FROM t1 or SELECT * FROM t2. If the request is a statement, the statement text is read and given to the parser. For a request read as a statement from the relay log on a replication slave: ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-text-p-9.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
