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/keyring-file-plugin.html
As of MySQL 8.0.34, this plugin is deprecated and subject to removal in a future release of MySQL. The keyring_file plugin supports the functions that comprise the standard MySQL Keyring service interface. The keyring_file keyring plugin stores ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html
MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later retrieval. MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL level, as ...As a C language interface, callable as a plugin service from server plugins or loadable ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-alter-table-performance-schema.html
Enable the stage/innodb/alter% instruments: mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' WHERE NAME LIKE 'stage/innodb/alter%'; Query OK, 7 rows affected (0.00 sec) Rows matched: 7 Changed: 7 Warnings: 0 Enable the stage ...
https://dev.mysql.com/doc/refman/8.0/en/option-modifiers.html
For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names at the beginning of query results. However, you may want to disable it in some instances, such as when sending the output ... Some options are “boolean” and control behavior that can be turned on or ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-firewall-tables.html
Note The Performance Schema tables described here are available as of MySQL 8.0.23. Prior to MySQL 8.0.23, use the corresponding INFORMATION_SCHEMA tables instead; see MySQL Enterprise Firewall Tables. The following sections describe the ...They ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. That might be useful, for example, after you have ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/8.0/en/perl-support.html
Although earlier versions are available, they do not support the full functionality of MySQL 8.0. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.0/en/replica-connection-thread-states.html
In MySQL 8.0.26, incompatible changes were made to instrumentation names, including the names of thread stages, containing the terms “master”, which is changed to “source”, “slave”, which is changed to “replica”, and “mts” (for ... These thread states occur on a replica server but are associated with connection threads, not with the I/O or SQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-replica.html
In MySQL 8.0.27 and later, asynchronous connection failover for replicas is activated automatically for a replication channel on a Group Replication primary when you set SOURCE_CONNECTION_AUTO_FAILOVER=1 in the CHANGE REPLICATION SOURCE TO ...The ...