https://dev.mysql.com/innodb-online-ddl-operations.html
Changing the column data type ALTER TABLE tbl_name CHANGE c1 c1 BIGINT, ALGORITHM=COPY; Changing the column data type is only supported with ALGORITHM=COPY. Online support details, syntax examples, and usage notes for DDL operations are provided ...
https://dev.mysql.com/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/compressed-format.html
For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) if all its values are in the range from -128 to 127. Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed ...
https://dev.mysql.com/partitioning-columns.html
The permitted data types are shown in the following list: All integer types: TINYINT, SMALLINT, MEDIUMINT, INT (INTEGER), and BIGINT. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS ...
https://dev.mysql.com/partitioning-overview.html
This section provides a conceptual overview of partitioning in MySQL 8.0. For information on partitioning restrictions and feature limitations, see Section 23.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...
https://dev.mysql.com/sys-ps-is-thread-instrumented.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN if the ID is unknown, or NULL if the ID is NULL. This is a value of the type given in the PROCESSLIST_ID column of the ...
https://dev.mysql.com/sys-ps-setup-disable-thread.html
Given a connection ID, disables Performance Schema instrumentation for the thread. This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Disable a ...
https://dev.mysql.com/mysql-nutshell.html
For example, a scalar INT or even BIGINT value actually requires very few bytes, so that the remainder of this space (up to 90% or more) was taken up by padding. This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/converting-tables-to-innodb.html
For the ranges of the different integer types, see Section 11.2.1, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT”. If you have MyISAM tables that you want to convert to InnoDB for better reliability and ...
https://dev.mysql.com/sys-ps-setup-enable-thread.html
Given a connection ID, enables Performance Schema instrumentation for the thread. This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST output. Enable a specific ...
