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/group-replication-data-definition-statements.html
In a Group Replication topology, care needs to be taken when executing data definition statements also commonly known as data definition language (DDL). Given that MySQL does not support atomic or transactional DDL, one cannot optimistically ...
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/programs-overview.html
It is usually executed only once, when first installing MySQL on a system. mysql_tzinfo_to_sql This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo database (the set of files describing time ...
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' ...
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/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 ...