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/performance-schema-replication-tables.html
Query results can be saved in tables for further analysis, or assigned to variables and thus used in stored procedures. This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
Each row summarizes events for a given stored program (stored procedure or function, trigger, or event). The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the PROCESSLIST_INFO value shows the SELECT statement. The threads table contains a row for each server thread. Each row contains information about a ...
https://dev.mysql.com/doc/refman/8.0/en/perl-installation.html
For example, to unpack and build a DBI distribution, use a procedure such as this: Unpack the distribution into the current directory: $> gunzip < DBI-VERSION.tar.gz | tar xvf - This command creates a directory named DBI-VERSION. MySQL Perl support ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
To uninstall a plugin that currently is loaded at server startup with a plugin-loading option, use this procedure. Server plugins must be loaded into the server before they can be used. It is also possible to control the activation state of loaded ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
A statement prepared in stored program context cannot refer to stored procedure or function parameters or local variables because they go out of scope when the program ends and would be unavailable were the statement to be executed later outside the ... 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/purge-binary-logs.html
To safely purge binary log files, follow this procedure: On each replica, use SHOW REPLICA STATUS to check which log file it is reading. PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that ...
https://dev.mysql.com/doc/refman/8.0/en/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
InnoDB ClusterSet and InnoDB Cluster are designed to abstract and simplify the procedures for setting up, managing, monitoring, recovering, and repairing replication groups. Beginning with MySQL 8.0.22, you can use the asynchronous connection ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL Keyring”).