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/account-upgrades.html
Notes: The upgrade operation just described is safe to execute at any time because it makes the mysql_native_password plugin explicit only for accounts that already use it implicitly. To upgrade these accounts to use mysql_native_password ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. The MySQL process list ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...The exception to this rule is that the query sees the changes made by earlier statements within the same ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
The expression just described has several implications for permitted table definitions: Using long column names can reduce the maximum number of columns, as can the inclusion of ENUM or SET columns, or use of column comments. MySQL represents each ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. The event scheduler thread does not run, is not shown in the output of SHOW PROCESSLIST, and no scheduled events ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
For the second call, the repertoire is UNICODE because the second argument is outside the ASCII range. IF(column1 < column2, 'smaller', 'greater') The result repertoire is ASCII because the two string arguments (the second argument and the third ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...For ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Error messages returned from the server to the client are converted to the client character set automatically, as with metadata. Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of ...
https://dev.mysql.com/doc/refman/5.7/en/replication.html
MySQL 5.7 also supports delayed replication such that a replica deliberately lags behind the source by at least a specified amount of time; see Section 16.3.10, “Delayed Replication”. Replication enables data from one MySQL database server (the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-tuning-recovery.html
Once the connection retry limit is reached the recovery procedure terminates with an error. In earlier versions of Group Replication, when reaching out to a donor, recovery could only detect connection errors due to authentication issues or some ...