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/binary-log-mixed.html
The warning is shown both in the client (in the output of SHOW WARNINGS) and through the mysqld error log. A warning is added to the SHOW WARNINGS table each time such a statement is executed. - Row Injection MIXED Yes Yes - ROW Row Injection ROW ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The binary log is not used for statements such as SELECT or SHOW that do not modify data. The Binlog_cache_use status variable shows the number of transactions that used this buffer (and possibly a temporary file) for storing statements. The ... The ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
The following table shows the plugin name on the client side. The following programs support the two options: mysql, mysqladmin, mysqlbinlog, mysqlcheck, mysqldump, mysqlimport, mysqlpump, mysqlshow, mysqlslap, mysqltest. The actual value differs ...
https://dev.mysql.com/doc/refman/5.7/en/channels-commands-single-channel.html
To enable MySQL replication operations to act on individual replication channels, use the FOR CHANNEL channel clause with the following replication statements: CHANGE MASTER TO START SLAVE STOP SLAVE SHOW RELAYLOG EVENTS FLUSH RELAY LOGS SHOW SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Handling Deadlocks You might see warning messages referring to “deadlocks” in the MySQL error log, or the output of SHOW ENGINE INNODB STATUS. You can test with the innodb_print_all_deadlocks option enabled to see all deadlock warnings in the ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
See also Section 13.7.5.18, “SHOW EVENTS Statement”, and Section 24.3.8, “The INFORMATION_SCHEMA EVENTS Table”. Note Statements such as SELECT or SHOW that merely return a result set have no effect when used in an event; the output from ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
The specifiers shown in the following table may be used in the format string. The unit value may be specified using one of keywords as shown, or with a prefix of SQL_TSI_. This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
To use MySQL 5.7 as a document store, the X Plugin needs to be installed. Then you can use X Protocol to communicate with the server. Without the X Plugin running, X Protocol clients cannot connect to the server. The X Plugin is supplied with MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
The information produced by many of the MySQL-specific SHOW statements can be obtained in more standard fashion by using SELECT to query INFORMATION_SCHEMA. MySQL Server supports some extensions that are likely not to be found in other SQL DBMSs.