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/innodb-performance-use_sys_malloc.html
This allocator is guarded by a single mutex, which may become a bottleneck. This parameter is not dynamic, and takes effect only when the system is started. When InnoDB was developed, the memory allocators supplied with operating systems and ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-service.html
This section describes how to use the keyring service functions to store, retrieve, and remove keys in the MySQL keyring keystore. If there is no user context, this value can be NULL. MySQL Server supports a keyring service that enables internal ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
This service is accessible at two levels: SQL interface: In SQL statements, call the functions described in Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”. For information about accessing this service and writing keyring ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
MySQL interprets this as a reference to the variable of that name rather than a column reference. The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third parameter that enables a locale to be ... The ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
However, in this case, the table is effectively empty and inserts fail because there is no underlying table to take new rows. This means that changes to the definitions of tables within a MERGE may cause a failure when the MERGE table is accessed.
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
This is the case if results can be produced entirely on the basis on information in the index tuples (through a covering index); MRR provides no benefit. Reading rows using a range scan on a secondary index can result in many random disk accesses ...
https://dev.mysql.com/doc/refman/5.7/en/myisamlog.html
Invoke myisamlog like this: myisamlog [options] [file_name [tbl_name] ...] The default operation is update (-u). This option can be given multiple times to produce more and more output. To create such a file, start the server with a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-troubleshooting.html
This is due to the fact that, for the duration of the restore process, running transactions get nonrepeatable reads from the restored data. This means that the state of the data is inconsistent while the restore is in progress. If an error code is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup.html
The next few sections describe how to prepare for and then to create an NDB Cluster backup using the functionality for this purpose found in the ndb_mgm management client. To distinguish this type of backup from a backup made using mysqldump, we ...