PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-other-options.html
If keys are packed (PACK_KEYS=1), myisamchk must unpack key blocks first, then re-create indexes and pack the key blocks again. myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
It reduces at an early stage of query execution the amount of data retrieved. Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their ...For ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
In the preceding discussion, the data set stored in tstable happens to consist of distinct UTC values. Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-memory.html
Is it reasonable that it should return so many rows? If not, correct the query and try again. This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server).
https://dev.mysql.com/doc/refman/8.0/en/windows-install-archive.html
Users who are installing from the noinstall package can use the instructions in this section to manually install MySQL.
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. Descending indexes also make it possible for the optimizer to use multiple-column indexes when the ... MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections. To ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. If the Performance Schema itself is disabled, ...The ...FORMAT_BYTES(count) Given a numeric byte count, converts it to human-readable format and returns a string consisting of a value and a units ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-views.html
Care should therefore be taken to ensure that views do not replicate table data that would normally be filtered for security reasons. Views are filtered by their own name, not by the tables they refer to. This means that a view can be replicated to ...Replication from a table to a same-named view is supported using statement-based logging, but not when using row-based ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions-charset.html
For operations that convert to character data, the character set and collation of the strings that result from the operations are defined by the character_set_connection and collation_connection system variables that determine the default connection ...This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's character set and collation are the same as those of the principal input ...