https://dev.mysql.com/innodb-performance-optimizer-statistics.html
As a result, different estimates could be produced when recomputing statistics, leading to different choices in execution plans and variations in query performance. This section describes how to configure persistent and non-persistent optimizer ...
https://dev.mysql.com/innodb-statistics-estimation.html
The default number of sampled pages is 8, which could be insufficient to produce an accurate estimate, leading to poor index choices by the query optimizer. Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when ...
https://dev.mysql.com/insert-select.html
This means that, when using replication, there is no guarantee that such a SELECT returns rows in the same order on the master and the slave, which can lead to inconsistencies between them. INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] ...
https://dev.mysql.com/insert.html
If the string value has no leading numeric part, the column is set to 0. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} ...
https://dev.mysql.com/installation-layouts.html
The installation layout differs for different installation types (for example, native packages, binary tarballs, and source tarballs), which can lead to confusion when managing different systems or using different installation sources. The ...
https://dev.mysql.com/invoking-programs.html
Nonoption arguments (arguments with no leading dash) provide additional information to the program. To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or ...
https://dev.mysql.com/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/manual-conventions.html
This manual uses certain typographical conventions: Text in this style is used for SQL statements; database, table, and column names; program listings and source code; and environment variables. Example: “To reload the grant tables, use the FLUSH ...
https://dev.mysql.com/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. As a result, the address value for rows within each name group is ...
https://dev.mysql.com/multiple-data-directories.html
This may lead to unpleasant surprises if your operating system does not support fault-free system locking. Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a data directory for a new ...
