Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression.html
The benefits are amplified for tables with secondary indexes, because index data is compressed also. This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is also ...
https://dev.mysql.com/doc/refman/8.4/en/is-null-optimization.html
For example, MySQL can use indexes and ranges to search for NULL with IS NULL. MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = constant_value. This optimization does not occur in cases when the column ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-block-size.html
This permits tuning of the performance of I/O operations for index files. To control the size of blocks in the .MYI index file of MyISAM tables, use the --myisam-block-size option at server startup. It is possible to specify the size of the block ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. Memory instruments have ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-binary.html
This is correct; # see Important note in text DataMemory=80M # Memory allocated to data storage IndexMemory=18M # Memory allocated to index storage # For DataMemory and IndexMemory, we have used the # default values. You should also have the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-foreign-keys.html
The foreign_keys table provides information about foreign keys on NDB tables.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-resources.html
Sum of DataMemory and IndexMemory, plus 8 pages of 32 KB each if IndexMemory has been set. This table provides information about data node resource availability and usage. The resources table contains the following columns: node_id The unique node ...
https://dev.mysql.com/doc/refman/8.4/en/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 ...