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-events-transactions-current-table.html
SOURCE The name of the source file containing the instrumented code that produced the event and the line number in the file at which the instrumentation occurs. The table stores one row per thread showing the current status of the thread's most ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering.html
Events are processed in a producer/consumer fashion: Instrumented code is the source for events and produces events to be collected. The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and ...| wait/synch/mutex/sql/LOCK_global_read_lock | YES | YES | | wait/synch/mutex/sql/LOCK_global_system_variables | YES | YES | | wait/synch/mutex/sql/LOCK_lock_db | YES | YES | | wait/synch/mutex/sql/LOCK_manager | YES | YES | ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instance-tables.html
They provide event names and explanatory notes or status information: cond_instances: Condition synchronization object instances file_instances: File instances mutex_instances: Mutex synchronization object instances rwlock_instances: Lock ...There ...Instrument names may have multiple parts and form a hierarchy, as discussed in Section 29.6, “Performance Schema Instrument Naming ...
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 ...