PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-system-monitoring.html
Issue: mysql-py> \sql SELECT enabled FROM performance_schema.setup_consumers WHERE NAME = 'events_statements_history' +---------+ | enabled | +---------+ | YES | +---------+ Check if all instruments report data to the consumer. Issue: mysql-py> \sql ... For general X Plugin monitoring, use the status variables that it ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
In this case, if a client connects as user1 from the local host, USER() and CURRENT_USER() return different values: mysql> SELECT USER(), CURRENT_USER(); +-----------------+----------------+ | USER() | CURRENT_USER() | ... Applications can use the ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
select_into_buffer_size: Size of buffer used for OUTFILE or DUMPFILE export file; overrides read_buffer_size. select_into_disk_sync: Synchronize data with storage device after flushing buffer for OUTFILE or DUMPFILE export file; OFF disables ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'audit%'; +-------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +-------------+---------------+ | audit_log | ACTIVE | ... This ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE TABLE. The CREATE TABLE part is logged using statement format and the SELECT part is logged according to the value of binlog_format. The ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For TEXT and BLOB columns, there is no padding on insert and no bytes are stripped on select. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the values they can hold. These ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different rows in the same column of the results of these operations would be in different character sets. When you use SELECT ... 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/8.0/en/charset-repertoire.html
Consider these statements: SET NAMES utf8mb4; SELECT 'abc'; SELECT _utf8mb4'def'; Although the character set is utf8mb4 in each of the preceding cases, the strings do not actually contain any characters outside the ASCII range, so their repertoire ... The repertoire of a character set is the collection of characters in the ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
Figure 2.2 Kleopatra: Lookup Certificates on Server Wizard: Finding a Certificate Select the "MySQL Release Engineering" certificate. Select our certificate, then from the main menu select Certificates, Change Owner Trust.... Select I believe checks ... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html
Add replication channels for the instance as shown in the following abbreviated example, using the binary log position that was transferred to the recipient during the cloning operation: mysql> SELECT BINLOG_FILE, BINLOG_POSITION FROM ...In addition ...