PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html
Columns using other data types relating to dates or times are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. All of these columns are taken into account ...COLUMNS partitioning enables the use of multiple columns in partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log.html
From MySQL 8.0.30, you can add statistics for the time and size of each query to detect outliers. MySQL Enterprise Audit uses the open MySQL Audit API to enable standard, policy-based monitoring, logging, and blocking of connection and query ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
For InnoDB, all DML operations (INSERT, UPDATE, DELETE) involving columns with full-text indexes are processed at transaction commit time. Full-text searches are supported for InnoDB and MyISAM tables only. The remarks for utf8mb3 also apply to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. The same reasoning applies to stopping and restarting the plugin with ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html
For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of Group Replication. However, while you are in the process of upgrading an online group, in order to maximize availability, ... Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-optimizer-statistics.html
Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the innodb_stats_auto_recalc configuration option to control whether statistics are updated automatically after substantial changes to a ... This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html
When the purge lag exceeds the innodb_max_purge_lag threshold, a delay is imposed on INSERT, UPDATE, and DELETE operations to allow time for purge operations to catch up. A row and its index records are only physically removed when InnoDB discards ... InnoDB does not physically remove a row from the database immediately when you delete it with an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-counters.html
The counters table provides running totals of events such as reads and writes for specific kernel blocks and data nodes. block_instance Block instance counter_id The counter's internal ID number; normally an integer between 1 and 10, inclusive. See ...Counts are kept from the most recent node start or restart; a node start or restart resets all counters on that ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-server.html
You can specify these options on the command line, through configuration files, or both. These variables reflect the current state and values of the startup options, some of which can be modified while the server is running. This setting modifies ...
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
If the preceding step does not work or does not apply, try to understand whether it would be safe to make the update manually (if needed) and then ignore the next statement from the source. If you are sure that the replica started out perfectly ...