Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
As of MySQL 9.3.0, you can create temporary tables that are stored in the MySQL HeatWave Cluster. A temporary table is visible only within the current session, and is dropped automatically when you close the session. Once created, you can use a ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-advantages.html
MERGE tables can help you solve the following problems: Easily manage a set of log tables. For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as ...This is much faster and saves a lot of disk ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables. If ...
https://dev.mysql.com/doc/refman/8.4/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory. Those reasons might include space management, I/O optimization, or placing tables on a storage device with particular ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables. Section 29.12.6, “Performance Schema Statement Event Tables” describes the events on which statement ...Example statement event summary information: mysql> SELECT * FROM performance_schema.events_statements_summary_global_by_event_name\G *************************** ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
ML_PREDICT_TABLE generates predictions for an entire table of trained data. Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, limit operations to batches of rows by splitting large tables into smaller tables by using ...The following example trains a dataset with the classification machine learning ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting data. Thus, it does not cause ...For more information, see Section 15.1.1, “Atomic Data Definition Statement ...