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/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-parallel-data-node-backup.html
In the general case, no additional special arguments are required; ndb_restore always checks for the existence of parallel subdirectories under the directory indicated by the --backup-path option and restores the metadata (serially) and then the ...
https://dev.mysql.com/doc/refman/8.0/en/stop-group-replication.html
STOP GROUP_REPLICATION does not complete until either the situation is resolved (for example, by the lock being released), or the component timeout expires and the modules are shut down regardless of their status. Beginning with MySQL 8.0.27, the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
update_latency The total wait time of timed update I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics_with_buffer and ... These views summarize table ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-analysis.html
The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. total_latency The total wait time of timed occurrences of the statement. max_latency The maximum single wait time of timed occurrences ...db The default database for the statement, or NULL if there is ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-latency.html
The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to ...rows_sent The total number of rows returned by statements for the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-latency.html
The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
To update cached values at any time for a given table, use ANALYZE TABLE information_schema_stats_expiry can be set to 0 to have INFORMATION_SCHEMA queries retrieve the latest statistics directly from the storage engine, which is not as fast as ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Returns a JSON object containing information about a ...
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS ...The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name or ...