PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-status-by-worker-table.html
This table provides details of the transactions handled by applier threads on a replica or Group Replication group member. For a single-threaded replica, data is shown for the replica's single applier thread. For a multithreaded replica, data is ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-metadata-table.html
The variables_metadata table shows, for each server system variable, its name, scope, type, range of values (where applicable), and description. VARIABLE_SCOPE The variable's scope; this is one of the values listed here: GLOBAL The variable is ...
https://dev.mysql.com/doc/refman/9.7/en/point-in-time-recovery-binlog.html
This section explains the general idea of using the binary log to perform a point-in-time-recovery. The next section, Section 9.5.2, “Point-in-Time Recovery Using Event Positions”, explains the operation in details with an example. Note Many of ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE.
https://dev.mysql.com/doc/refman/9.7/en/privileges-provided.html
The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html
Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...
https://dev.mysql.com/doc/refman/9.7/en/resetting-permissions.html
If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL Account”. If you know the root ...
https://dev.mysql.com/doc/refman/9.7/en/security-against-attack.html
When you connect to a MySQL server, you should use a password. All other information is transferred as text, and can be read by anyone who is able to watch the connection. If the connection between the client and the server goes through an ...