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-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-lock-waits.html
The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, as a TIME value. waiting_trx_age How long the waiting transaction has been ... These views summarize the InnoDB locks that transactions are waiting ...
https://dev.mysql.com/doc/refman/8.0/en/sys-waits-global-by-latency.html
The waits_global_by_latency and x$waits_global_by_latency views have these columns: events The event name. total_latency The total wait time of timed occurrences of the event. avg_latency The average wait time per timed occurrence of the event.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
Explicitly defined transactions (with a START TRANSACTION or BEGIN statement) are subject to the timeout, disconnection, and incoming transaction blocking even if they do not modify any data. There is no default setting for the timeout, so if you do ...The current primary becomes a read-only secondary, and the specified group member becomes the read-write ... The ...
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/8.0/en/charset-se-me-sets.html
South European and Middle Eastern character sets supported by MySQL include Armenian, Arabic, Georgian, Greek, Hebrew, and Turkish. armscii8 (ARMSCII-8 Armenian) collations: armscii8_bin armscii8_general_ci (default) cp1256 (Windows Arabic) ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-directories.html
When data is cloned, the following directories and files are created for internal use. *.#clone files: Temporary data files created on the recipient while data is removed from the recipient data directory and new data is cloned during a remote ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-function-reference.html
Table 8.46 MySQL Enterprise Data Masking and De-Identification Component Functions Name Description gen_blocklist() Perform dictionary term replacement gen_dictionary() Return random term from dictionary gen_range() Generate random number within ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-function-reference.html
Table 8.47 MySQL Enterprise Data Masking and De-Identification Plugin Functions Name Description Deprecated gen_blacklist() Perform dictionary term replacement Yes gen_blocklist() Perform dictionary term replacement gen_dictionary_drop() Remove ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin.html
MySQL Enterprise Data Masking and De-Identification is based on a plugin library that implements these elements: A server-side plugin named data_masking. A set of loadable functions provides an SQL-level API for performing masking and ...