PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
To enable GTID transactions: On each server, execute: SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = WARN; Let the server run for a while with your normal workload and monitor the logs. On each server, execute: SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = ON; ...Before you start, ensure that the servers meet the following pre-conditions: All servers in your topology must use MySQL 5.7.6 or ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
An internal buffer that is exposed as a table in the performance_schema database is named after the table, without parentheses. The Status information is in the form of comma-delimited set of name/value pairs. SHOW ENGINE engine_name {STATUS | ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
For example, MeCab tokenizes “データベース管理” (“Database Management”) into “データベース” (“Database”) and “管理” (“Management”). To install and configure the MeCab parser plugin, perform the following ...To ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
ndb-cluster-connection-pool-nodeids: Comma-separated list of node IDs for connections to cluster used by MySQL; number of nodes in list must match value set for --ndb-cluster-connection-pool. ndb-mgmd-host: Set host (and port, if desired) for ...For ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. You can ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
User lock The thread is going to request or is waiting for an advisory lock requested with a GET_LOCK() call. It is deleting only from the first table, and saving columns and offsets to be used for deleting from the other (reference) tables. It is ...Many of these are useful only for finding bugs in the ... The following list describes thread State values that are associated with general query ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable conversion between string and internal format IPv6 address formats, and checking whether values represent valid ...IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and ... Support for IPv6 in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names setting. NAME The name of the table, preceded by the schema (database) name where appropriate (for example, ...
https://dev.mysql.com/doc/refman/5.7/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. For more information on the postinstallation procedures, see Section 2.9, “Postinstallation Setup and Testing”. Before You Start As a popular, open-source software, MySQL, in ...Follow these steps: Go to the Download MySQL Yum Repository page (https://dev.mysql.com/downloads/repo/yum/) in the MySQL Developer ...