PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-system-monitoring.html
Issue: mysql-py> \sql SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments WHERE NAME LIKE 'statement/%' AND NOT (ENABLED and TIMED) If this statement reports at least one row, you need to enable the instruments. We use MySQL Shell ... For general X Plugin monitoring, use the status variables that it ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
As of MySQL 8.0.14, the audit_api_message_emit component enables applications to add their own message events to the audit log, using the audit_api_message_emit_udf() function. For concreteness, examples use the audit_log plugin described in ...If ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-installation.html
For remote cloning operations, the clone plugin must be installed on the donor and recipient MySQL server instances. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
MySQL 8.0.22 and later supports derived condition pushdown for eligible subqueries. Note Prior to MySQL 8.0.22, if a derived table was materialized but not merged, MySQL materialized the entire table, then qualified all of the resulting rows with ...When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the derived table should decrease the number of rows that need to be processed and thus speed up execution of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
IS_UPDATABLE MySQL sets a flag, called the view updatability flag, at CREATE VIEW time. Notes MySQL permits different sql_mode settings to tell the server the type of SQL syntax to support. For example, you might use the ANSI SQL mode to ensure ...
https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23). (CHANGE REPLICATION SOURCE TO option: SOURCE_CONNECT_RETRY, CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption.html
From MySQL 8.0.14, binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/8.0/en/source-ssl-library-configuration.html
If the installed OpenSSL version is older than 1.0.1, CMake produces an error at MySQL configuration time. If you compile MySQL from a source distribution, CMake configures the distribution to use the installed OpenSSL library by default. The ... An ...