PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-performance-timers-table.html
For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event Timing”. For a cycle timer, the frequency is generally related to the CPU speed. For example, on a system with a 2.4GHz processor, the CYCLE may be ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
DESIRED_DELAY The number of seconds that the replica must lag the source. This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at runtime with the CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
If joe connects from hosta.example.com, the connection matches the second inserted row. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html
The second part describes how third-party connector developers can determine the extent to which a connector can take advantage of pluggable authentication capabilities and what steps to take to become more compliant. When a client connects to the ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
This privilege is required to manipulate your own secondary password because most users require only one password. If an account is to be permitted to manipulate secondary passwords for all accounts, it should be granted the CREATE USER privilege ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
Because that row has a Host value 'localhost' that is more specific than '%', it is used in preference to the new row when connecting from localhost! The correct procedure is to insert a second row with Host='localhost' and User='some_user', or to ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
Table Repair Considerations REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/replication-administration-status.html
Seconds_Behind_Source: The number of seconds that the replication SQL (applier) thread is behind processing the source binary log. A value of 0 for Seconds_Behind_Source can usually be interpreted as meaning that the replica has caught up with the ... 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 ...