Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-show-tables.html
By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as well. --type, -t Can be used to restrict the output to one type of object, specified ... ndb_show_tables displays a list of all NDB database objects in the ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-benchmarking.html
With simple tests, you usually test how changing one aspect (a configuration setting, the set of indexes on a table, the SQL clauses in a query) affects performance. The most important feature to try with each workload is the adaptive hash index for ... To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-blob.html
Rather than testing for equality against a very long text string, you can store a hash of the column value in a separate column, index that column, and test the hashed value in queries. When storing a large blob containing textual data, consider ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Turning the adaptive hash indexing feature on and off using the innodb_adaptive_hash_index option. Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-cond-instances-table.html
The cond_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (NAME) TRUNCATE TABLE is not permitted for the cond_instances table. The cond_instances table lists all the conditions seen by the Performance Schema while ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-instances-table.html
The file_instances table has these indexes: Primary key on (FILE_NAME) Index on (EVENT_NAME) TRUNCATE TABLE is not permitted for the file_instances table. The file_instances table lists all the files seen by the Performance Schema when executing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-queries.html
These indexes also improve performance for related objects, such as sys schema views that use those tables. Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-coordinator-table.html
The replication_applier_status_by_coordinator table has these indexes: Primary key on (CHANNEL_NAME) Index on (THREAD_ID) The following table shows the correspondence between replication_applier_status_by_coordinator columns and SHOW REPLICA STATUS ... For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator ...