Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-config-values.html
The config_values table provides information about the current state of node configuration parameter values. Each row in the table corresponds to the current value of a parameter on a given node. The config_values table contains the following ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-logbuffers.html
The logbuffer table provides information on NDB Cluster log buffer usage. The logbuffers table contains the following columns: node_id The ID of this data node. One each of these log_type rows is shown in the logbuffers table for each data node in ...One of these rows has the log type BACKUP-DATA, which shows the amount of data buffer used during backup to copy fragments to backup ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-threadstat.html
The threadstat table provides a rough snapshot of statistics for threads running in the NDB kernel. Since this table contains counts taken at a given point in time, for best results it is necessary to query this table periodically and store the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-transporter-details.html
This table contains information about individual NDB transporters, rather than aggregate information as shown by the transporters table. The transporter_details table displays a row showing the status of each transporter in the cluster. See the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-truncate.html
TRUNCATE TABLE is normally regarded as a DML statement, and so would be expected to be logged and replicated using row-based format when the binary logging mode is ROW or MIXED. However this caused issues when logging or replicating, in STATEMENT ...
https://dev.mysql.com/doc/refman/9.7/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because the data is vulnerable to crashes, hardware issues, or power outages, only use these tables as temporary work areas ...A typical use case for the MEMORY engine involves these characteristics: Operations involving transient, non-critical data such as session management or ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-0-0.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). (Bug #35205358) Data Dictionary Notes Attempting to upgrade a MyISAM table containing a mix of ...File name timestamp value is missing or invalid: 'dbname'' when no audit log file was being ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-examples-compression-sect.html
Example 17.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 17.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...The ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. If you want to check a table, you should normally run myisamchk without options or with the -s (silent) option. This may take a long time for a ...What it cannot find is corruption that involves only the data file (which is very ...