Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The setup_objects table has these indexes: Index on (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME) TRUNCATE TABLE is permitted for the setup_objects table. The setup_objects table controls whether the Performance Schema monitors particular objects. This ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-summary-tables.html
The socket summary tables have these indexes: socket_summary_by_event_name: Primary key on (EVENT_NAME) socket_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for socket summary tables.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variable-tables.html
The global_variables and session_variables tables have these indexes: Primary key on (VARIABLE_NAME) The variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the system variable is defined. The ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
TP_GROUP_ID The index of the thread group in the global array. CONNECT_HANDLER_INDEX The index of the connection handler thread in the group which processed the connection request; a higher number means the connection load has triggered the creation ... The tp_connections table contains one row per connection managed by the Thread Pool ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
row *************************** EVENT_NAME: wait/synch/mutex/sql/BINARY_LOG::LOCK_index COUNT_STAR: 8 SUM_TIMER_WAIT: 2119302 MIN_TIMER_WAIT: 196092 AVG_TIMER_WAIT: 264912 MAX_TIMER_WAIT: 569421 ... The Performance Schema maintains tables for ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-doxygen.html
The MySQL source code contains internal documentation written using Doxygen. It is also possible to generate this content locally from a MySQL source distribution using the following procedure: Install doxygen 1.9.2 or later. After installing ...
https://dev.mysql.com/doc/refman/8.4/en/static-format.html
It is also the fastest of the on-disk formats due to the ease with which rows in the data file can be found on disk: To look up a row based on a row number in the index, multiply the row number by the row length to calculate the row position. MyISAM ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-1.html
(Bug #36453684) NDB Replication: The binary log index purge callback was skipped for the replica applier, which caused orphan rows to be left behind in the ndb_binlog_index table. (Bug #34754817) In some cases, when trying to perform an online add ... MySQL NDB Cluster 8.4.1 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including features in version 8.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-forecasting-model.html
The model uses this column as an index for the forecast variable. The following data types for this column are supported: DATETIME, TIMESTAMP, DATE, TIME, and YEAR, or an auto-incrementing index. Therefore, the predict table must not overlap the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-rpd-columns-table.html
DATA_PLACEMENT_INDEX The data placement key index ID associated with the column. The rpd_columns table provides column encoding information for columns of tables loaded in the MySQL AI Engine. The rpd_columns table has these columns: TABLE_ID A ...