PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-print-backup-file.html
Usage ndb_print_backup_file file_name file_name is the name of a cluster backup file. This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup directory. These files are found in the data node's backup directory under the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-thread-by-current-bytes.html
By default, rows are sorted by descending amount of memory used. The memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes views have these columns: thread_id The thread ID. current_count_used The current number of allocated ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-data-definition-statements.html
In a Group Replication topology, care needs to be taken when executing data definition statements also commonly known as data definition language (DDL). Given that MySQL does not support atomic or transactional DDL, one cannot optimistically ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-usage-advice-and-limitations-of-distributed-recovery.html
This means that if the data to transfer is too big at phase 1, the server may take a very long time to recover. That way, one minimizes the time spent on the recovery step. It is based on classic asynchronous replication and as such it may be slow ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
The caching and batch flushing behavior avoids frequent updates to auxiliary index tables, which could result in concurrent access issues during busy insert and update times. If you create a full-text index at CREATE TABLE time and do not specify an ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-mysql-memory-use.html
The TIMED column in the setup_instruments table is ignored for memory instruments because memory operations are not timed. The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
This table also shows the total time spent waiting for locks successfully and unsuccessfully since fragment or table creation, or since the most recent restart. This is also true for the time values shown in the wait_ok_millis and wait_fail_millis ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Lock requests that have timed out and are waiting for the requesting session's lock request to be discarded. When a pending lock request times out (ER_LOCK_WAIT_TIMEOUT), its row status is updated from PENDING to TIMEOUT. The VICTIM, TIMEOUT, and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
The following example compares the difference between execution times when exchanging a partition with a nonpartitioned table, with and without validation. Exchanging Partitions Without Row-By-Row Validation To avoid time consuming validation when ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-observability.html
Nonetheless, you might sometimes need to understand what is happening behind the scenes. There is a lot of automation built into the Group Replication plugin. This is where the instrumentation of Group Replication and Performance Schema becomes ...