Search Results
https://dev.mysql.com/doc/refman/8.4/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. An index may use a prefix of ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkt-functions.html
These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier (SRID). For a description of WKT format, see Well-Known Text (WKT) Format. ST_GeomFromText() accepts a WKT value of any ...Functions in this section detect arguments in either Cartesian or geographic spatial reference systems (SRSs), and return results appropriate to the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
EVENT_DEFINITION The text of the SQL statement making up the event's DO clause; in other words, the statement executed by this event. EVENT_COMMENT The text of the comment, if the event has one. The EVENTS table provides information about Event ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
ROUTINE_DEFINITION The text of the SQL statement executed by the routine. ROUTINE_COMMENT The text of the comment, if the routine has one. The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
Character strings often compress well, whether defined in CHAR, VARCHAR, TEXT or BLOB columns. Compressing in the Application If you compress data such as text in your application, before it is inserted into the database, You might save overhead for ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
Encryption is supported for the InnoDB FULLTEXT index tables that are created implicitly when adding a FULLTEXT index. Instead, InnoDB ensures that the text to be encrypted is a multiple of the block size. InnoDB supports data-at-rest encryption ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
For example, you might hit this limit with a column prefix index of more than 191 characters on a TEXT or VARCHAR column, assuming a utf8mb4 character set and the maximum of 4 bytes for each character. LONGBLOB and LONGTEXT columns must be less than ... This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage ...