Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-threadstat.html
The threadstat table provides a rough snapshot of statistics for threads running in the NDB kernel. The values of the os_ru_utime, os_ru_stime, os_ru_minflt, os_ru_majflt, os_ru_nvcsw, and os_ru_nivcsw columns are obtained using the system ...
https://dev.mysql.com/doc/refman/8.4/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. sendbuffer_used_bytes The amount, in bytes, of signal data currently awaiting send by this transporter.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-index-stat.html
ndb_index_stat provides per-fragment statistical information about indexes on NDB tables. This includes cache version and age, number of index entries per partition, and memory consumption by indexes. Running ndb_index_stat with the --update option ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs result in CPU and I/O operations at the hardware level, which you must minimize and make as ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable Optimizations”). Changes to this variable affect execution of all subsequent queries; to affect one query differently ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Because the InnoDB storage engine performs many of its ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 8.4. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-component-scheduler-tasks-table.html
The component_scheduler_tasks table contains a row for each scheduled task. Each row contains information about the ongoing progress of a task that applications, components, and plugins can implement, optionally, using the scheduler component (see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema and require no ...