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-compression-internals.html
This adaptive algorithm is sensitive to whether the system is running in an I/O-bound or CPU-bound manner. This section describes some internal implementation details about compression for InnoDB tables. The information presented here may be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-internal-data.html
As these tables contain sensitive information (at least INNODB_LOCKS.LOCK_DATA and INNODB_TRX.TRX_QUERY), for security reasons, only the users with the PROCESS privilege are allowed to SELECT from them. The data exposed by the transaction and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
memcached stores and retrieves keys and values in bytes and is therefore not character set-sensitive. This section describes issues that you may encounter when using the InnoDB memcached plugin. If you encounter the following error in the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_read_ahead_threshold Command-Line Format --innodb-read-ahead-threshold=# System Variable innodb_read_ahead_threshold Scope Global Dynamic Yes Type Integer Default Value 56 Minimum Value 0 Maximum Value 64 Controls the sensitivity of linear ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
The configuration parameter innodb_read_ahead_threshold controls how sensitive InnoDB is in detecting patterns of sequential page access. A read-ahead request is an I/O request to prefetch multiple pages in the buffer pool asynchronously, in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
To avoid import problems on case-sensitive operating systems such as Linux and Unix, create all databases, tablespaces, and tables using lowercase names. This section describes how to import tables using the Transportable Tablespaces feature, which ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the plugin. plugin_name is the name ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
The functions in this section modify JSON values and return the result. JSON_APPEND(json_doc, path, val[, path, val] ...) Appends values to the end of the indicated arrays within a JSON document and returns the result. This function was renamed to ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. The implementation comprises these elements: Keyring plugins that manage a backing store or communicate ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...