PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-log-status-table.html
This is the generated unique value of the read-only system variable server_uuid. The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
The OBJECT_INSTANCE_BEGIN column is a property that uniquely identifies the mutex. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-member-stats-table.html
This also serves as a key because it is unique to each member. The replication_group_member_stats table has these columns: CHANNEL_NAME Name of the Group Replication channel VIEW_ID Current view identifier for this group. This has a different value ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html
This also serves as a key because it is unique to each member. This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and should not be ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. The table contains one row per TCP/IP or Unix socket file connection. Information available in this table provides a real-time snapshot of the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html
The statement histogram summary tables have these indexes: events_statements_histogram_by_digest: Unique index on (SCHEMA_NAME, DIGEST, BUCKET_NUMBER) events_statements_histogram_global: Primary key on (BUCKET_NUMBER) TRUNCATE TABLE is permitted for ... The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
If an instrument is used to create multiple instances, each instance has a unique OBJECT_INSTANCE_BEGIN value and is summarized separately in this table. The Performance Schema maintains tables for collecting current and recent wait events, and ...
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
These unique IDs can serve as pointers to corresponding rows in other tables when you join tables using foreign keys. The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
The optimizer estimates the cost of reading qualifying rows for equality range comparisons as follows: If there is a unique index on col_name, the row estimate for each range is 1 because at most one row can have the given value. Otherwise, any ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata repository. If binary log file position based replication is in use, when the replica restarts, it reads the two ...