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/performance-schema-table-handles-table.html
For information about these lock types, see the include/thr_lock.h source file. The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html
UDF_LIBRARY The name of the library file containing the executable function code. The file is located in the directory named by the plugin_dir system variable. The user_defined_functions table contains a row for each loadable function registered ...
https://dev.mysql.com/doc/refman/8.0/en/query-attribute-components.html
URN: file://component_query_attributes Developers who wish to incorporate the same query-attribute component service used by query_attributes should consult the mysql_query_attributes.h file in a MySQL source distribution. The query_attributes ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids.html
Because GTID-based replication is completely transaction-based, it is simple to determine whether sources and replicas are consistent; as long as all transactions committed on a source are also committed on a replica, consistency between the two is ... This section explains transaction-based replication using global transaction identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-configuration.html
The replica replicates one database from each of the sources, db1 from source1 and db2 from source2. See Section 19.1.2.1, “Setting the Replication Source Configuration” for how to configure a source using file position based replication. In ...
https://dev.mysql.com/doc/refman/8.0/en/show-master-status.html
SHOW MASTER STATUS This statement provides status information about the binary log files of the source server. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql ...It requires ...
https://dev.mysql.com/doc/refman/8.0/en/show-replicas.html
Replica_UUID: The globally unique ID of this replica, as generated on the replica and found in the replica's auto.cnf file. {SHOW REPLICAS} Displays a list of replicas currently registered with the source. Host: The host name of the replica server, ...From MySQL 8.0.22, use SHOW REPLICAS in place of SHOW SLAVE HOSTS, which is deprecated from that ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-avg-latency.html
These views summarize wait class average latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_avg_latency and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-latency.html
These views summarize wait class total latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_latency and ...
https://dev.mysql.com/doc/refman/8.0/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql may also be used in batch mode: you place your queries in a file beforehand, then tell mysql to execute ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...