Search Results
https://dev.mysql.com/doc/refman/8.4/en/displaying-traces.html
Examining a trace in the mysql command-line client can be made less difficult using the pager less command (or your operating platform's equivalent). INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines.
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Use the dropdowns for additional filters to select Description—contains, and enter “Docker” in the text field. Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
Columns used in comparisons cannot be of any of the BLOB or TEXT types. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-format.html
Log parsers can treat these fields as parts of the message text that is present only for logs written by servers recent enough to include them. Each error log sink (writer) component has a characteristic output format it uses to write messages to ...
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
Because of changes to data (and supporting statistics) it may produce a different result from running EXPLAIN on the equivalent query text. To obtain the execution plan for an explainable statement executing in a named connection, use this ...
https://dev.mysql.com/doc/refman/8.4/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Data types The MEDIUMINT, SET, and ENUM data types, and the various BLOB and TEXT data types. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
Is it possible to use FULLTEXT indexes with NDB Cluster? A.10.23. Is it possible to use FULLTEXT indexes with NDB Cluster? FULLTEXT indexing is currently supported only by the InnoDB and MyISAM storage engines. In the following section, we answer ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
For example, creating a FEDERATED table fails if the table uses an index prefix on any VARCHAR, TEXT or BLOB columns. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a ...