PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html
Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? A.16.2. How much space does InnoDB use for the change buffer? A.16.5. How do I determine the current size of the change buffer? A.16.6. Where can I find additional ...
https://dev.mysql.com/doc/refman/5.7/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient memory for the buffer pool without sacrificing transactional features or reliability. The adaptive ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking.html
To prevent possible crashes or data corruptions when InnoDB opens an ib-file set, it checks that it can fully support the file formats in use within the ib-file set. If the system is restarted following a crash, or a “fast shutdown” (i.e., ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
InnoDB mutexes and rw-locks are typically reserved for short intervals. On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. If the mutex or ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different keystore. A successful migration operation has this result: The destination keystore contains the keys it had prior to the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its output. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-backups.html
This section discusses making backups and restoring from them using NDB Cluster replication. We assume that the replication servers have already been configured as covered previously (see Section 21.7.5, “Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
MySQL enables database administrators to expire account passwords manually, and to establish a policy for automatic password expiration. Expiration policy can be established globally, and individual accounts can be set to either defer to the global ...