PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
MySQL supports one structured variable type, which specifies parameters governing the operation of key caches. A key cache structured variable has these components: key_buffer_size key_cache_block_size key_cache_division_limit ... A structured ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
Certificates rely on asymmetric encryption algorithms that have two encryption keys (a public key and a secret key). Any data encrypted using this public key can be decrypted only using the corresponding secret key, which is held by the owner of the ... With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
When you define a PRIMARY KEY on a table, InnoDB uses it as the clustered index. If there is no logical unique and non-null column or set of columns to use a the primary key, add an auto-increment column. If you do not define a PRIMARY KEY for a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
If innodb_large_prefix is enabled (the default), the index key prefix limit is 3072 bytes for InnoDB tables that use the DYNAMIC or COMPRESSED row format. If innodb_large_prefix is disabled, the index key prefix limit is 767 bytes for tables of any ... This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
The single row of data in the demo_test table has a key value of AA. When you restart MySQL, get operations once again return the key-value pairs you stored in the earlier memcached session. When a key is requested and the associated value is not ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-tuning.html
get key_value Using System Memory For best performance, deploy the daemon_memcached plugin on machines that are configured as typical database servers, where the majority of system RAM is devoted to the InnoDB buffer pool, through the ... Because ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
Unique key reads have their locks upgraded automatically by NDB to ensure a self-consistent read; BLOB reads also employ extra locking for consistency. You can help minimize issues with shared read locks by avoiding queries that use unique key ... A ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
To make it easier to support secure connections, MySQL servers compiled using OpenSSL can automatically generate missing SSL and RSA certificate and key files at startup. See Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
These two statements are equivalent: SHOW COLUMNS FROM mytable FROM mydb; SHOW COLUMNS FROM mydb.mytable; The optional FULL keyword causes the output to include the column collation and comments, as well as the privileges you have for each column.