Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-running-queries.html
When MySQL HeatWave is enabled and the data you want to query is loaded, queries that qualify are automatically offloaded from the DB System to MySQL HeatWave for accelerated processing. Simply run the query from a client, application, or interface ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...
https://dev.mysql.com/doc/workbench/en/wb-performance-query-statistics.html
The Query Stats SQL editor results tab (see the next two figures) uses Performance Schema data to gather key statistics collected for executed query, such as timing, temporary tables, indexes, joins, and more. Figure 7.5 SQL Editor: Query Stats ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-gr-memory-monitoring-ps-sample-queries.html
This section describes sample queries using the instruments and events for monitoring Group Replication memory usage. The memory data can be queried for individual events, for example: SELECT * FROM ...row *************************** EVENT_NAME: ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. This is a good way to make queries faster if you have a ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 7.6.4.1, “Installing or Uninstalling the Rewriter Query Rewrite Plugin”). To ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-reporting-builtin-query.html
The built-in MySQL Shell report query executes the single SQL statement that is provided as an argument, and returns the results using MySQL Shell's reporting facility. You can use the query report as a convenient way to generate simple reports for ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/formatting-queries-reference.html
It is possible to format the query result with wiki markup. This enables you to display information from the query directly in the event generated by the advisor. This example lists the user name and host for all accounts without a defined password. See Section 31.1.7, “Wiki Format” for more information on the supported wiki ...
https://dev.mysql.com/doc/refman/8.4/en/query-attribute-components.html
A component service provides access to query attributes (see Section 11.6, “Query Attributes”). The query_attributes component uses this service to provide access to query attributes within SQL statements. Purpose: Implements the ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
This plugin also supports a privilege (SKIP_QUERY_REWRITE) that protects a given user's queries from being rewritten. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server ...