https://dev.mysql.com/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/innodb-memcached-intro.html
Standard memcached protocols, including the text-based protocol and the binary protocol. The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL layer. The ...
https://dev.mysql.com/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/installing-source-distribution.html
To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.9.2, “Source Installation Prerequisites”. Obtain a distribution file using the instructions in Section 2.1.2, ...
https://dev.mysql.com/keyring-hashicorp-plugin.html
cat company.crt >> vault.crt If you open the vault.crt file with a text editor, its content should look like this: -----BEGIN CERTIFICATE----- ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/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/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/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 16.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...
https://dev.mysql.com/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
