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/server-loadable-functions.html
MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove capabilities. MySQL Enterprise Edition includes a ...For ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
SHOW SLAVE HOSTS should be executed on a server that acts as a replication source. This is the server ID of the server on which SHOW SLAVE HOSTS is executed, so this same value is listed for each row in the result. SHOW SLAVE HOSTS Displays a list ...
https://dev.mysql.com/doc/refman/5.7/en/corrupted-myisam-tables.html
You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time. Typical symptoms of a corrupt table are: You get the following error while selecting data from the table: Incorrect key ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
It is assumed that you establish passwords with CREATE USER at account-creation time to avoid creating insecure accounts. From the mysql program, GRANT responds with Query OK, 0 rows affected when executed successfully. This behavior is by design, ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
NDB Cluster requires communication between data nodes and API nodes (including SQL nodes), as well as between data nodes and other data nodes, to execute queries and updates. In addition, to maintain consistency and service despite the silent ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
Merging cached changes at a later time, when affected pages are read into the buffer pool by other operations, avoids substantial random access I/O that would be required to read secondary index pages into the buffer pool from disk. The change ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
Modifications to any of these tables affect monitoring immediately, with some exceptions: Modifications to some instruments in the setup_instruments table are effective only at server startup; changing them at runtime has no effect. That might be ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
For csh and tcsh, use setenv to make the shell variable available to the environment: setenv MYSQL_TCP_PORT 3306 The commands to set environment variables can be executed at your command prompt to take effect immediately, but the settings persist ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. Do ... To tune queries for InnoDB tables, create an appropriate set of indexes on each ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where GTIDs are in use (gtid_mode is ON), issuing RESET MASTER resets the GTID execution history. The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see mysql.gtid_executed ...