Search Results
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/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/refman/8.4/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...The THREAD_ID and EVENT_ID values taken together uniquely identify the ...
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations-ml-explain-table.html
ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, use the batch_size option to limit operations to batches of 10 to 100 rows by splitting ...
https://dev.mysql.com/doc/refman/8.4/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. A derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral derived tables are ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Depending on error log configuration, the server can also write the most recent error events to the Performance Schema error_log table. Granting the SELECT privilege for the error_log table thus gives clients and applications access to error log ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named table. To use this statement, you must have some privilege for the table. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL ...That is, a CHECK constraint originally specified as part of a column definition displays as a separate clause not part of the column ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...For information about row format characteristics, see Section 17.10, “InnoDB Row ...