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/ndb-restore-parallel-data-node-backup.html
NDB Cluster 8.0 supports parallel backups on each data node using ndbmtd with multiple LDMs (see Section 25.6.8.5, “Taking an NDB Backup with Parallel Data Nodes”). The next two sections describe how to restore backups that were taken in this ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-many-tables.html
If you have configured non-persistent optimizer statistics (a non-default configuration), InnoDB computes index cardinality values for a table the first time that table is accessed after startup, instead of storing such values in the table. This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-event-tables.html
For wait, stage, statement, and transaction events, the Performance Schema can monitor and store current events. In addition, when events end, the Performance Schema can store them in history tables. For each event type, the Performance Schema uses ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common resource. The work performed while holding a mutex is said to be in a “critical section,” and multiple queries ... The mutex_instances table lists all the mutexes seen by the Performance Schema while the server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_TIMESTAMP A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the most recent I/O error took place. LAST_HEARTBEAT_TIMESTAMP A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the most recent ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-recover.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. For instructions to do this, see Section 9.5, “Point-in-Time (Incremental) Recovery”. If the PRIVILEGE_CHECKS_USER account should have been ... If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
Rewriter_number_reloads The number of times the rewrite_rules table has been loaded into the in-memory cache used by the Rewriter plugin. Rewriter_reload_error Whether an error occurred the most recent time that the rewrite_rules table was loaded ...
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. Prior to the introduction of sorted index builds, index entries were inserted into the B-tree one record at a time using insert APIs.
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io.html
io_latency The total wait time of timed file I/O events for the host. By default, rows are sorted by descending total file I/O latency. The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the ...