Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
row *************************** ENGINE: PERFORMANCE_SCHEMA SUPPORT: YES COMMENT: Performance Schema TRANSACTIONS: NO XA: NO SAVEPOINTS: NO mysql> SHOW ENGINES\G ... Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance Schema Transactions: NO ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
MANAGEMENT_TIME The accumulated time between the return from waiting on file descriptors; this includes the time spent queued for queries which are not executed directly. The tp_connections table contains one row per connection managed by the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
These tables can be queried using SELECT statements like other tables. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has these characteristics: The Performance Schema provides ...
https://dev.mysql.com/doc/refman/8.4/en/primary-key-optimization.html
The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance benefits from the NOT NULL optimization, because it cannot include any NULL values. With the InnoDB storage engine, the ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. In the select list of a query, a quoted column ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
Oracle Corporation also provides the MySQL Workbench GUI tool, which is used to administer MySQL servers and databases, to create, execute, and evaluate queries, and to migrate schemas and data from other relational database management systems for ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
When replication is running correctly, issue STOP REPLICA followed by RESET REPLICA (both on the replica), then verify that no unwanted data from the test queries exists on the replica. Note This statement takes the place of the old RESET MASTER ...