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/mysql-cluster-privilege-distribution.html
Invoke the stored procedure like this: mysql> CALL mysql.mysql_cluster_move_privileges(); Query OK, 0 rows affected (22.32 sec) Depending on the number of rows in the privilege tables, this procedure may take some time to execute. Note For clients ...This is not needed when connecting a new SQL node to the cluster for the first ... NDB Cluster ...
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/ipv6-system-support.html
As a simple test to determine whether that is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 bytes from ::1, icmp_seq=1 hlim=64 time=0.077 ms ... Before MySQL Server can accept IPv6 connections, the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-tables-with-full-table-scans.html
latency The total wait time of full scans of the table. These views display which tables are being accessed with full table scans. The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples-compression-sect.html
Compressing or uncompressing pages has consumed less than a second since the time the statistics were reset, because the columns COMPRESS_TIME and UNCOMPRESS_TIME are zero. This copying of SUM(PAGE_SIZE*RELOCATION_OPS) bytes has consumed less than a ... Example 14.1 Using the Compression Information Schema Tables The following is sample output from a database that contains compressed tables (see Section 14.9, “InnoDB Table and Page Compression”, INNODB_CMP, INNODB_CMP_PER_INDEX, and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
Note StartNoNodegroupTimeout must be the same for all data nodes in the cluster; for this reason, you should always set it in the [ndbd default] section of the config.ini file, rather than for individual data nodes. In this section we provide a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-usage-advice-and-limitations-of-distributed-recovery.html
This means that if the data to transfer is too big at phase 1, the server may take a very long time to recover. That way, one minimizes the time spent on the recovery step. It is based on classic asynchronous replication and as such it may be slow ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between performance and reliability, consistency, and reproducibility of results when multiple transactions are making changes and performing ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
If you kill myisampack, the .TMD file might not be deleted.) Normally, myisampack exits with an error if it finds that tbl_name.TMD exists. When the table is used later, the server reads into memory the information needed to decompress columns. This ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
You want to use a column containing date or time values, or containing values arising from some other series. For example, when executing a query such as EXPLAIN SELECT COUNT(*) FROM employees WHERE separated BETWEEN '2000-01-01' AND '2000-12-31' ...