Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/memory-storage-engine.html
To synchronize master and slave MEMORY tables, when a MEMORY table is used on a master for the first time since it was started, a DELETE statement is written to the master's binary log, to empty the table on the slaves also. The server needs ... The ...
https://dev.mysql.com/multiple-key-caches.html
The CACHE INDEX statement sets up an association between a table and a key cache, but the association is lost each time the server restarts. If you want the association to take effect each time the server starts, one way to accomplish this is to use ... Note As of MySQL 8.0, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/myisam-storage-engine.html
Table 16.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/mysql-cluster-config-file.html
config.ini: This file, sometimes known as the global configuration file, is read only by the NDB Cluster management server, which then distributes the information contained therein to all processes participating in the cluster. (If you build NDB ...
https://dev.mysql.com/mysql-cluster-config-starting.html
NoOfFragmentLogFiles=300 DataDir=path/to/data/node/data/directory MaxNoOfConcurrentOperations=100000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 # Setting these parameters allows you to take advantage of real-time ...
https://dev.mysql.com/mysql-cluster-ndbinfo-nodes.html
For each data node that is running in the cluster, a corresponding row in this table provides the node's node ID, status, and uptime. uptime integer Time since the node was last started, in seconds. The uptime column shows the time in seconds that ... This table contains information on the status of data ...
https://dev.mysql.com/mysql-cluster-ndbinfo-transporters.html
The following table provides information about the columns in the transporters table. For each column, the table shows the name, data type, and a brief description. Additional information can be found in the notes following the table. This ...
https://dev.mysql.com/mysql-cluster-online-add-node-example.html
Note StartNoNodegroupTimeout must be the same for all data nodes in the cluster; for this reason, you should always set it in the [ndbd default] section of the config.ini file, rather than for individual data nodes. In this section we provide a ...
https://dev.mysql.com/mysql-cluster-programs-ndb-config.html
This consists of system variables that cannot be changed at run time; thus, there is no corresponding section of the cluster configuration file for them. Similarly, the default restart type is node (that is, an online or “rolling” restart of the ... This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an NDB Cluster management node, or its config.ini or my.cnf ...
https://dev.mysql.com/mysql-cluster-programs-ndb-mgm.html
The length of time to wait per attempt is set using --connect-retry-delay. The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in providing a set of commands for checking the cluster's status, starting ...
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-time-p-31.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.
