https://dev.mysql.com/innodb-fulltext-index.html
FULLTEXT indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as stopwords. The words are fully sorted and ...A FULLTEXT index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE ...
https://dev.mysql.com/insert.html
Inserting a string into a string column (CHAR, VARCHAR, TEXT, or BLOB) that exceeds the column's maximum length. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name ...
https://dev.mysql.com/internal-temporary-tables.html
Presence of any string column with a maximum length larger than 512 (bytes for binary strings, characters for nonbinary strings) in the SELECT list, if UNION or UNION ALL is used. The TempTable storage engine provides efficient storage for VARCHAR ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/json.html
MySQL handles strings used in JSON context using the utf8mb4 character set and utf8mb4_bin collation. Strings in other character sets are converted to utf8mb4 as necessary. (For strings in the ascii or utf8 character sets, no conversion is needed ...
https://dev.mysql.com/keywords.html
However, by default, no whitespace is permitted in function invocations between the function name and the following ( character. Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers ...
https://dev.mysql.com/merge-table-problems.html
In some cases, differing PACK_KEYS table option values among the MERGE and underlying tables cause unexpected results if the underlying tables contain CHAR or BINARY columns. The following are known problems with MERGE tables: In versions of MySQL ...
https://dev.mysql.com/monitor-innodb-mutex-waits-performance-schema.html
shell> ./mysqlslap --auto-generate-sql --concurrency=100 --iterations=10 --number-of-queries=1000 --number-char-cols=6 --number-int-cols=6; Query the wait event data. A mutex is a synchronization mechanism used in the code to enforce that only one ...
https://dev.mysql.com/myisam-storage-engine.html
MyISAM tables have the following characteristics: All data values are stored with the low byte first. MyISAM also supports the following features: Support for a true VARCHAR type; a VARCHAR column starts with a length stored in one or two bytes.
https://dev.mysql.com/myisamchk-general-options.html
This is often the case when you have large key values for CHAR, VARCHAR, or TEXT columns, because the sort operation needs to store the complete key values as it proceeds. The options described in this section can be used for any type of table ...
