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-deadlocks.html
If deadlock detection is disabled using the innodb_deadlock_detect variable, InnoDB relies on the innodb_lock_wait_timeout setting to roll back transactions in case of a deadlock. If frequent deadlocks highlight a problem with transaction structure ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
This is a one-time operation, which can be performed by installing an RPM provided by MySQL. A password for the superuser is set and stored in the error log file. Before You Start As a popular, open-source software, MySQL, in its original or ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
To cause the server to refuse or permit LOAD DATA LOCAL statements explicitly (regardless of how client programs and libraries are configured at build time or runtime), start mysqld with local_infile disabled or enabled. Clients that make no ... The ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
However, this is not the case: The second query returns 0. mysql> SELECT STRCMP(@s1, @s3); ERROR 1267 (HY000): Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for operation 'strcmp' mysql> SELECT STRCMP(@s1, ... Table 12.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the resulting string is also a binary ...
https://dev.mysql.com/doc/refman/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/5.7/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/5.7/en/federated-storage-engine.html
The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. To include the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression.html
The benefits are amplified for tables with secondary indexes, because index data is compressed also. This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is referred ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-macos-quick.html
To install MySQL Shell on macOS, do the following: Download the package from http://dev.mysql.com/downloads/shell/. Figure 19.2 Installation of MySQL Shell on macOS When the installer finishes, eject the DMG.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-news.html
Changes in NDB Cluster releases are documented separately from this reference manual; you can find release notes for the changes in each NDB Cluster 7.5 release at NDB 7.5 Release Notes, and for each NDB Cluster 7.6 release at NDB 7.6 Release Notes. You can obtain release notes for older versions of NDB Cluster from NDB Cluster Release ...