PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
Indexing only a prefix of column values in this way can make the index file much smaller. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. If a search term exceeds the index ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
MySQL uses the default collation for this character set (utf8_general_ci) for all searches, sorts, comparisons, and other string operations on such columns. Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
To support proximity search, position information for each word is also stored, as a byte offset. The number of threads that perform this work is configurable using the innodb_ft_sort_pll_degree variable. The index defined on the opening_lines table ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
This means that if you issue several plain (nonlocking) SELECT statements within the same transaction, these SELECT statements are consistent also with respect to each other. For locking reads (SELECT with FOR UPDATE or LOCK IN SHARE MODE), UPDATE, ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
For instructions to do this, see Section 7.5, “Point-in-Time (Incremental) Recovery”. Does the transaction that stopped replication need to be applied on the replica? If so, either make the appropriate corrections and reapply the transaction, or ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
EVENT_DEFINITION The text of the SQL statement making up the event's DO clause; in other words, the statement executed by this event. EXECUTE_AT For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-using-management-client.html
This identifier is saved in the cluster log, if it has not been configured otherwise. At this point in the backup process the cluster has received and processed the backup request. This can be overridden for one or more data nodes individually, or ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
This is preferable in a production deployment to installing the plugin manually. This is important when setting up Group Replication as it ensures you can configure the server before manually starting the plugin. This section explains the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
To use this capability to initialize a MySQL installation, if you previously invoked mysql_install_db manually, invoke mysqld with the --initialize or --initialize-insecure option, depending on whether you want the server to generate a random ...A ...