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/charset-metadata.html
Error messages returned from the server to the client are converted to the client character set automatically, as with metadata. Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
The expression just described has several implications for permitted table definitions: Using long column names can reduce the maximum number of columns, as can the inclusion of ENUM or SET columns, or use of column comments. MySQL represents each ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. row *************************** Trigger: ins_sum Event: INSERT Table: account ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
Deadlocks affect performance rather than representing a serious error, because InnoDB automatically detects deadlock conditions and rolls back one of the affected transactions. At times, it may be more efficient to disable deadlock detection and ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
TLS is sometimes referred to as SSL (Secure Sockets Layer) but MySQL does not actually use the SSL protocol for encrypted connections because its encryption is weak (see Section 6.3.2, “Encrypted Connection TLS Protocols and Ciphers”). The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory.
https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
This is more secure than giving the password on the command line, which might enable other users on your system to see the password line by executing a command such as ps. If named-pipe connections are not supported or if the user making the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
This is a “cold start” procedure that assumes either that you are starting the replication source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source, see ...