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/functions.html
Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET statements. Expressions can be written using values ...
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANGE MASTER TO MASTER_DELAY = N; An event received from the source is not executed until at least N seconds later than its execution on the source. MySQL 5.7 supports ...The exceptions are that there is no delay for format description events or log file rotation events, which affect only the internal state of the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| statement/sql/load | YES ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_encrypted_file keyring plugin stores keyring data in an encrypted, password-protected file local to the server host.
https://dev.mysql.com/doc/refman/5.7/en/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named MYSET.xml. <map> elements appear within these elements: <ctype> defines attributes for each character. <collation> elements indicate character ordering for comparison and sorting, one element per ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. It does not provide information about internal InnoDB temporary tables used by the optimizer. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. --connect-retries Command-Line Format --connect-retries=# ...--core-file Command-Line Format --core-file Write core file on error; used in ...By default, it waits for the cluster to ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
Set the variable to the maximum file size for your system, after checking to be sure that there is enough free space to hold a copy of the table files. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of ...
https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html
When using MySQL with logging enabled, you may want to back up and remove old log files from time to time and tell MySQL to start logging to new files. If you are using replication, you should set the variable no lower than the maximum number of ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
Use UPGRADE DATA DIRECTORY NAME in this case to explicitly tell the server to re-encode the database directory name to the current encoding format: ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME; After executing this statement, you can ...ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a ...