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/mysql-cluster-ndbinfo-restart-info.html
Each entry in the table corresponds to a node restart status report in real time from a data node with the given node ID. The restart_info table contains the following columns: node_id Node ID in the cluster node_restart_status Node status; see text ...Only the most recent report for any given node is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-tc-time-track-stats.html
The tc_time_track_stats table provides time-tracking information obtained from the DBTC block (TC) instances in the data nodes, through API nodes access NDB. index_key_ops Based on duration of successful unique index key operations, tracked against ...Each TC instance tracks latencies for a set of activities it undertakes on behalf of API nodes or other data nodes; these activities include transactions, transaction errors, key reads, key writes, unique index operations, failed key operations of any type, scans, failed scans, fragment scans, and failed fragment ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-threadblocks.html
The threadblocks table associates data nodes, threads, and instances of NDB kernel blocks. The threadblocks table contains the following columns: node_id Node ID thr_no Thread ID block_name Block name block_instance Block instance number Notes The ...Although the list of possible values is static for a given NDB Cluster release, the list may vary between ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-blackhole.html
When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. With the statement based logging format, all statements affecting BLACKHOLE tables are logged, but their effects ignored. When ...
https://dev.mysql.com/doc/refman/8.0/en/sys-extract-table-from-file-name.html
Given a file path name, returns the path component that represents the table name. It provides a convenient way to display table names, which can be more easily understood than full path names, and can be used in joins against object table names.
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). After that, the dump becomes lock-free and does not disturb reads and writes on the tables. It was assumed earlier that ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
This option prevents the replication applier from taking actions such as creating temporary tables and executing LOAD DATA INFILE requests, which increases the security of the channel. If you are using statement-based replication and temporary ...] ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-ddl-operations.html
Many DDL operations on tables and indexes (CREATE, ALTER, and DROP statements) can be performed online. Online DDL support for adding secondary indexes means that you can generally speed up the process of creating and loading a table and associated ...Use TRUNCATE TABLE to empty a table, not DELETE FROM ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
It is recommended that you never give any ACL privileges to the PRIVILEGE_CHECKS_USER account, including CREATE USER, CREATE ROLE, DROP ROLE, and GRANT OPTION, and do not permit the account to update the mysql.user table. Executing internal-use ...