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-thread-filtering.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For the Performance Schema to monitor a thread, these things must be true: The ...
https://dev.mysql.com/doc/refman/9.7/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. The server then authenticates the client, determining from ...
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/problems-connecting.html
If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the problem. To correct this when you invoke a client program, specify a --port option to indicate ...
https://dev.mysql.com/doc/refman/9.7/en/regexp.html
This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression operations. MySQL implements regular ...
https://dev.mysql.com/doc/refman/9.7/en/repair-table.html
[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines only. Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data ...
https://dev.mysql.com/doc/refman/9.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/9.7/en/replica-sql-thread-states.html
The following list shows the most common states you may see in the State column for a replication SQL thread on a replica server. Set the terminology_use_previous system variable with session scope to support individual functions, or global scope ...
https://dev.mysql.com/doc/refman/9.7/en/replication-administration-status.html
The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the source. The SHOW REPLICA STATUS statement, which you must execute on each replica, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover-source.html
To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this channel. GTID auto-positioning must be in use for the channel (SOURCE_AUTO_POSITION = ...