Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-summary-tables.html
Each stage summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event instruments in the setup_instruments table: events_stages_summary_by_account_by_event_name has EVENT_NAME, ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...The ranges of values for the arguments are as follows: M is the maximum number of digits (the ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
Issuing RESET BINARY LOGS AND GTIDS or RESET REPLICA resets the values shown in these columns. In other words, this column is useful only for fast networks. This timestamp uses the format YYMMDD hh:mm:ss, and appears in the Last_IO_Error_Timestamp ... SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
SHOW TABLE STATUS output has these columns: Name The name of the table. With the removal of .frm files in MySQL 8.0, this column now reports a hardcoded value of 10, which was the last .frm file version used in MySQL 5.7. (In-memory data resource ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-redundant-indexes.html
In the following column descriptions, the dominant index is the one that makes the redundant index redundant. The schema_redundant_indexes view has these columns: table_schema The schema that contains the table. The x$schema_flattened_keys view has ... The schema_redundant_indexes view displays indexes that duplicate other indexes or are made redundant by ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
In all the individual descriptions below, the column labeled “Dump From Example File” has the exact bytes that are in T.MYI. Name Size Dump From Example File Comment ---- ---- ---------------------- ------- /* key definition for I1 */ ... A .MYI ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-23-u1.html
Functionality Added or Changed String column encoding support was added for TEXT-type columns. The following temporal functions are now supported with VARLEN-encoded columns: TO_DAYS() DAYOFYEAR() QUARTER() TO_SECONDS() See Temporal Functions. The ...The clauses are now supported at any location in a query that is permitted by ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
Blackhole Engine and Auto Increment Columns The BLACKHOLE engine is a no-op engine. This should be borne in mind when considering the behavior of primary key columns that auto increment. In this scenario replication fails with a duplicate entry ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
The description for SHOW COLUMNS provides more information about the output columns. By default, DESCRIBE displays information about all columns in the table. col_name, if given, is the name of a column in the table. In this case, the statement ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...