PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
The following statement is invalid because it contains one list of nine values, rather than three lists of three values each: INSERT INTO tbl_name (a,b,c) VALUES(1,2,3,4,5,6,7,8,9); VALUE is a synonym for VALUES in this context. The trailing ...
https://dev.mysql.com/doc/refman/8.0/en/installing-source-distribution.html
To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation Prerequisites”. Obtain a distribution file using the instructions in Section 2.1.3, ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
If the key file is password-protected, the ssl directory can contain a single-line text file named password.txt containing the password needed to decrypt the key file. For example, use a command like this, and enter the encryption password at the ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
For example, to disable InnoDB mutex wait event instruments related to full-text search, add the following rule: performance-schema-instrument='wait/synch/mutex/innodb/fts%=OFF' Note Rules with a longer prefix such as wait/synch/mutex/innodb/fts% ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...