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/multiple-server-clients.html
If you normally use a specific socket file or port number, you can place commands to set these environment variables in your .login file so that they apply each time you log in. Start the client with --protocol=TCP to connect using TCP/IP, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. Additionally, there ...
https://dev.mysql.com/doc/refman/5.7/en/system-schema.html
Time Zone System Tables These system tables contain time zone information: time_zone: Time zone IDs and whether they use leap seconds. For more information, see Section 5.1.13, “MySQL Server Time Zone Support”. Replication System Tables The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. If a statement returns an error, the commit or rollback behavior depends ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...
https://dev.mysql.com/doc/refman/5.7/en/xa-states.html
The following error is raised if you try to execute such a statement: ERROR 1399 (XAE07): XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state Statements to which the preceding remark applies are listed at ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
Although historically big redo log files caused lengthy recovery times, recovery is now much faster and you can confidently use large redo log files. Consider the following guidelines for optimizing redo logging: Make your redo log files big, even ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
For stored routines (procedures and functions), the database character set and collation in effect at routine creation time are used as the character set and collation of character data parameters for which the declaration includes no CHARACTER SET ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
This operation does not perform an implicit UNLOCK TABLES, so an error results if you perform the operation while there is any active LOCK TABLES or use it a second time without first releasing the locks acquired. FLUSH DES_KEY_FILE Reloads the DES ...| table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html
An SQL statement sent by the application to a server not in the required state produces an error. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent ...