https://dev.mysql.com/load-data.html
If all the input lines have a common prefix that you want to ignore, you can use LINES STARTING BY 'prefix_string' to skip the prefix and anything before it. If a line does not include the prefix, the entire line is skipped. The third row in the ...
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/numeric-type-overview.html
For floating-point and fixed-point types, M is the total number of digits that can be stored. DEC[(M[,D])] [UNSIGNED] [ZEROFILL], NUMERIC[(M[,D])] [UNSIGNED] [ZEROFILL], FIXED[(M[,D])] [UNSIGNED] [ZEROFILL] These types are synonyms for DECIMAL. The ...For additional information about properties and storage requirements of the numeric types, see Section 11.2, “Numeric Types”, and Section 11.8, “Data Type Storage ...
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-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/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-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 ...
