PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
Many option files are plain text files, created using any text editor. In the latter context, if “x” is not a valid escape sequence character, \x becomes “x” rather than \x. Most MySQL programs can read startup options from option files ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
There are two exceptions to this restriction: When partitioning by [LINEAR] KEY, it is possible to use columns of any valid MySQL data type other than TEXT or BLOB as partitioning keys, because the internal key-hashing functions produce the correct ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
It also includes the full text of error messages to support more free-form analysis. Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
To change this value, set the performance_schema_max_sql_text_length system variable at server startup. DIGEST_TEXT The normalized statement digest text, or NULL if the statements_digest consumer is no. Consequently, values selected from the ...The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-worker-table.html
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE The message text for the last transient error that caused the transaction to be retried. APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE The message text for the last transient error that ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-binlog.html
To view events from the log, send mysqlbinlog output into a paging program: $> mysqlbinlog binlog_files | more Alternatively, save the output in a file and view the file in a text editor: $> mysqlbinlog binlog_files > tmpfile $> ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
preparable_stmt is either a string literal or a user variable that contains the text of the SQL statement. A statement prepared in stored program context cannot refer to stored procedure or function parameters or local variables because they go out ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage operation of the MySQL server. In replication context, the PASSWORDLESS_USER_ADMIN privilege applies ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
CREATE FUNCTION GTID_INTERSECTION(gs1 LONGTEXT, gs2 LONGTEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs1, GTID_SUBTRACT(gs1, gs2)) | This function returns the symmetric difference between two GTID sets, that is, the GTIDs that exist in gs1 but not in ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
noblob: Log all columns (same as full), except for BLOB and TEXT columns that are not required to identify rows, or that have not changed. This system variable cannot be changed within the context of a transaction. This system variable cannot be ...