PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-probes-and-statistics.html
The monitoring mechanism works by having each member deploying a set of probes to collect information about its work queues and throughput. Such probes are scattered throughout the plugin stack and allow one to establish metrics, such as: the ...It ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-type.html
These views summarize information about statements executed, grouped by host and statement type. By default, rows are sorted by host and descending total latency. The host_summary_by_statement_type and x$host_summary_by_statement_type views have ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-type.html
These views summarize information about statements executed, grouped by user and statement type. By default, rows are sorted by user and descending total latency. The user_summary_by_statement_type and x$user_summary_by_statement_type views have ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
MODIFIED_COUNTER The number of rows modified by DML operations, such as INSERT, UPDATE, DELETE, and also cascade operations from foreign keys. The rate at which the AUTOINC value changes depends on how many times auto-increment numbers have been ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-processlist-table.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. Important INFORMATION_SCHEMA.PROCESSLIST is deprecated and subject to removal in a future MySQL ...As such, the implementation of SHOW PROCESSLIST which uses this table is also ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
Note When adding FTS_DOC_ID column at table creation time, ensure that the FTS_DOC_ID column is updated when the FULLTEXT indexed column is updated, as the FTS_DOC_ID must increase monotonically with each INSERT or UPDATE. If you choose not to add ...To disable autocommit during your import operation, surround it with SET autocommit and COMMIT statements: SET autocommit=0; ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-disconnecting.html
To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. Contact your administrator to find out what connection parameters you should use to connect (that is, what host, user name, ...If the server runs on a machine other than the one where you log in, you must also specify a host ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-variables.html
This section describes the system and status variables that the CONNECTION_CONTROL plugin provides to enable its operation to be configured and monitored. For information about how connection_control_failed_connections_threshold interacts with ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
LAST_ALTERED The date and time when the routine was last modified. DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. The ROUTINES table provides information about stored routines (stored procedures and ...The ROUTINES table does not include built-in (native) functions or loadable ...