Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysql-cluster-backup-using-management-client.html
Before starting a backup, make sure that the cluster is properly configured for performing one. If an existing backup_id value is used, the backup fails with the error Backup failed: file already exists. If used, the backup_id must follow START ...
https://dev.mysql.com/mysql-cluster-limitations-performance.html
Unique hash indexes created with USING HASH cannot be used for accessing a table if NULL is given as part of the key. The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance ...
https://dev.mysql.com/mysql-cluster-management.html
(Recall that node_id represents the unique identifier of the node whose activity is being logged.) The cluster log contains event reports generated by ndbd. Managing an NDB Cluster involves a number of tasks, the first of which is to configure and ...
https://dev.mysql.com/mysql-cluster-ndbinfo-cluster-locks.html
This information can be used to help identify the unique entries in a list of lock requests. The lock ID (lockid column) is unique to this node and block instance. The cluster_locks table provides information about current lock requests holding and ...
https://dev.mysql.com/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...
https://dev.mysql.com/mysql-cluster-ndbinfo-memory-per-fragment.html
The memory_per_fragment table provides information about the usage of memory by individual fragments. The following table provides information about the columns in the memory_per_fragment table. For each column, the table shows the name, data type, ...
https://dev.mysql.com/mysql-cluster-ndbinfo-server-locks.html
This information can be used to help identify the unique entries in a list of lock requests. The lock ID (lockid column) is unique to this node and block instance. The server_locks table is similar in structure to the cluster_locks table, and ...
https://dev.mysql.com/mysql-cluster-ndbinfo-tc-time-track-stats.html
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 ... 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 ...
https://dev.mysql.com/mysql-cluster-programs-ndb-size-pl.html
Memory requirements for all of the tables, attributes, ordered indexes, and unique hash indexes defined in the database. This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were ...
https://dev.mysql.com/mysql-cluster-replication-general.html
Each MySQL server used for replication in either cluster must be uniquely identified among all the MySQL replication servers participating in either cluster (you cannot have replication servers on both the master and slave clusters sharing the same ... A replication channel requires two MySQL servers acting as replication servers (one each for the master and ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-unique-p-13.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
