PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-security.html
memcached clients are only able to access InnoDB tables that are registered in the innodb_memcache.containers table. Even though a DBA can place access restrictions on such tables, access through memcached applications cannot be controlled. For this ... Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-types.html
Table 6.23, “General Keyring Key Length Limits” shows the general key-length limits. (The lower limits for keyring_aws are imposed by the AWS KMS interface, not the keyring functions.) Table 6.24, “Keyring Plugin Key Types and Lengths” shows ... MySQL Keyring supports keys of different types (encryption algorithms) and lengths: The available key types depend on which keyring plugin is ...
https://dev.mysql.com/doc/refman/5.7/en/locking-issues.html
MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple threads. External locking occurs when the server and other programs lock ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. It is a fast way to generate random numbers on demand that is portable between ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
To fix any compression issues that occur with ARCHIVE tables, use OPTIMIZE TABLE. If possible, classify reports as “live” or as “statistical”, where data needed for statistical reports is created only from summary tables that are generated ... This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
If you specify the columns in the right order in the index definition, a single composite index can speed up several kinds of queries on the same table. If the table has a multiple-column index, any leftmost prefix of the index can be used by the ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-memory.html
If you are going to use myisamchk on very large tables, you should first decide how much memory you want it to use. The following formula yields the amount of space required: (largest_key + row_pointer_length) * number_of_rows * 2 You can check the ...myisamchk uses no more memory than its memory-related variables are set ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-exclusive-to-cluster.html
NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a binary log for tables having BLOB columns but no primary key. The following are limitations specific to the NDB storage engine: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logging-management-commands.html
The following table describes the default setting (for all data nodes) of the cluster log category threshold. Table 21.48 Cluster log categories, with default threshold setting Category Default threshold (All data nodes) STARTUP 7 SHUTDOWN 7 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-management.html
The values of these variables can be read in the mysql client from the output of a SHOW STATUS statement, or by querying either the SESSION_STATUS table or the GLOBAL_STATUS table (in the INFORMATION_SCHEMA database). By comparing the values of the ... Managing an NDB Cluster involves a number of tasks, the first of which is to configure and start NDB ...