PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-rbr-monitoring.html
For example to get progress for update events issue: mysql> SELECT WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current -> WHERE EVENT_NAME LIKE 'stage/sql/Applying batch of row changes (update)' If ... The current progress ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-main.html
The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding replication. For information on source states, see Section 10.14.4, “Replication Source Thread States”. For replica ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
For stored-routine operations, the server uses the procs_priv table rather than tables_priv and columns_priv. After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue through the connection, the ...
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
As stored in the grant tables, they have the same properties as account names, which are described in Grant Table Scope Column Properties. MySQL role names refer to roles, which are named collections of privileges. Role names have syntax and ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-context-mysql-feature-ports.html
If you enable certain MySQL features, you might need to set the SELinux TCP port context for additional ports used by those features. If ports used by MySQL features do not have the correct SELinux context, the features might not function correctly. The following sections describe how to set port contexts for MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/server-side-help-support.html
This information is stored in several tables in the mysql schema (see Section 7.3, “The mysql System Schema”). MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP ...
https://dev.mysql.com/doc/refman/8.0/en/show-character-set.html
Maxlen The maximum number of bytes required to store one character. SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if present, indicates which ...
https://dev.mysql.com/doc/refman/8.0/en/show-engines.html
row *************************** Engine: MEMORY Support: YES Comment: Hash based, stored in memory, useful for temporary tables Transactions: NO XA: NO Savepoints: NO *************************** 9. SHOW [STORAGE] ENGINES SHOW ENGINES displays status ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
Cardinality is counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
The value of Seconds_Behind_Source is based on the timestamps stored in events, which are preserved through replication. SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the ...