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/downgrade-troubleshooting.html
If you downgrade from one release series to another, there may be incompatibilities in table storage formats. In this case, use mysqldump to dump your tables before downgrading. After downgrading, reload the dump file using mysql or mysqlimport to ...For examples, see Section 2.10.13, “Copying MySQL Databases to Another ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
One way to make collisions detectable is to make the hash column a primary key. The alternative permitted block encryption modes CBC, CFB1, CFB8, CFB128, and OFB all require an initialization vector. Both HKDF and PBKDF2 can use salts, and their use ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-storage-engines.html
Where can I obtain complete documentation for MySQL storage engines? See Chapter 15, Alternative Storage Engines. The disabled_storage_engines configuration option defines which storage engines cannot be used to create tables or tablespaces. MySQL ...Where can I obtain complete documentation for MySQL storage engines? ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
For example: mysql> GET DIAGNOSTICS CONDITION 1 @p5 = SCHEMA_NAME, @p6 = TABLE_NAME; mysql> SELECT @p5, @p6; +------+------+ | @p5 | @p6 | +------+------+ | | | +------+------+ In standard SQL, if there are multiple conditions, the first condition ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
To tell MySQL to accept the query, you can use the ANY_VALUE() function: SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name; Alternatively, disable ONLY_FULL_GROUP_BY. SQL-92 and earlier does not permit queries for which the select ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
Detecting Partitions The replication_group_members performance schema table presents the status of each server in the current view from the perspective of this server. The majority of the time the system does not run into partitioning, and therefore ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. The following list indicates possible causes of and fixes for this ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
This access method merges index scans from a single table only, not scans across multiple tables. AND key_partN = constN Any range condition over the primary key of an InnoDB table. If all columns used in the query are covered by the used indexes, ... The Index Merge access method retrieves rows with multiple range scans and merges their results into ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. InnoDB tables arrange your data on disk to optimize queries based on primary keys. Each InnoDB table ...