Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-pitr.html
Performing point-in-time recovery of NDB Cluster tables with NDB Cluster and NDB Cluster Replication can be accomplished using a native NDB data backup (taken by issuing CREATE BACKUP in the ndb_mgm client) and restoring the ndb_binlog_index table ... Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-networking-issues.html
Applications using the cluster and user of those applications must not be permitted to have direct access to the management and data node hosts. In this section, we discuss basic network security issues as they relate to NDB Cluster. It is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-summary-tables.html
In this way, aggregations at higher levels are available directly without the need for user-defined views that sum lower-level columns. COUNT_MISC, SUM_TIMER_MISC, MIN_TIMER_MISC, AVG_TIMER_MISC, MAX_TIMER_MISC These columns aggregate all other I/O ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-mutex-instances-table.html
When some code creates a mutex, a row is added to the mutex_instances table. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Modifications to any of these tables affect monitoring immediately, with the exception that modifications to the setup_actors table affect only ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-stats-table.html
WAKE_THREAD_STALL_CHECKER The number of times the stall check thread decided to wake or create a thread to possibly handle some statements or take care of the waiter thread role. USER_LOCK_WAITS The number of THD_WAIT_USER_LOCK waits for a special ...The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-state-table.html
The tp_thread_state table has one row per thread created by the thread pool to handle connections. The tp_thread_state table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
If a user attempts to do so with UNINSTALL PLUGIN, an error occurs. For example, if the plugin implements a storage engine, existing tables for the storage engine become inaccessible, and attempts to create new tables for the storage engine result ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
By default, the server creates binary log files in the data directory, but a path name can be specified with the --log-bin option to place the files in a different location. For example: $> mysqlbinlog --read-from-remote-server --host=host_name ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption.html
MySQL binary log files and relay log files can be encrypted, helping to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating ...The encryption algorithm used for the files, the AES (Advanced Encryption Standard) cipher algorithm, is built in to MySQL Server and cannot be ...