Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysql-cluster-online-operations.html
row *************************** Level: Warning Code: 1478 Message: DYNAMIC column c4 with STORAGE DISK is not supported, column will become FIXED mysql> SHOW CREATE TABLE t1\G *************************** 1. row *************************** Level: ...
https://dev.mysql.com/bug-reports.html
Search the bugs database at http://bugs.mysql.com/ to see whether the bug has been reported and fixed. A good bug report, containing a full test case for the bug, makes it very likely that we will fix the bug in the next release. Any bug that we are ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/myisamchk-table-info.html
varchar prefix 0 1024 87 80 varchar 0 3 168 3 multip. For strings, it may be shorter than the full length of the indexed column, because you can index a prefix of a string column. Packed MySQL tries to pack key values that have a common suffix. This ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/mysql-cluster-ndbinfo-memory-per-fragment.html
The memory_per_fragment table provides information about the usage of memory by individual fragments. The following table provides information about the columns in the memory_per_fragment table. For each column, the table shows the name, data type, ...
https://dev.mysql.com/data-size.html
Many languages can be written primarily using single-byte utf8 characters, so a fixed storage length often wastes space. (InnoDB compressed tables are readable and writable, while MyISAM compressed tables are read-only.) For MyISAM tables, if you do ... Design your tables to minimize their space on the ...
https://dev.mysql.com/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...
https://dev.mysql.com/mysql-cluster-limitations-database-objects.html
In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that violates this limitation fails with NDB error 851 Maximum offset for fixed-size columns exceeded. NDB Cluster 8.0 supports a ...
https://dev.mysql.com/mysql-cluster-programs-ndb-restore.html
The path may be absolute or relative to the directory in which the ndb_restore executable is located, and may be optionally prefixed with backup_path=. --exclude-intermediate-sql-tables[=TRUE|FALSE] Property Value Command-Line Format ... The NDB ...
https://dev.mysql.com/mysql-nutshell.html
When sorting JSON values in a query using ORDER BY, each value is now represented by a variable-length part of the sort key, rather than a part of a fixed 1K in size. This change has the following benefits for performance: Sort buffer space is now ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/mysqlcheck.html
--defaults-group-suffix=str Read not only the usual option groups, but also groups with the usual names and a suffix of str. If the --defaults-group-suffix=_other option is given, mysqlcheck also reads the [client_other] and [mysqlcheck_other] ...
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-fixed-p-2.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.
