Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
To view the current MySQL HeatWave query history, query the performance_schema.rpd_query_stats table: mysql> SELECT query_id, LEFT(query_text,160) FROM performance_schema.rpd_query_stats; *************************** 1. row ... Auto Query Time ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
Scheduling Firewall Cache Reloads Each time the MYSQL_FIREWALL server-side plugin initializes, it loads data from these tables to its internal cache: firewall_whitelist firewall_group_allowlist firewall_users firewall_groups firewall_membership ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER TABLE t1 ALTER INDEX i_idx VISIBLE; Information about whether an index is visible or invisible is available from the Information Schema STATISTICS table or SHOW INDEX output.
https://dev.mysql.com/doc/refman/8.4/en/myisam-crash-recovery.html
If your tables become corrupted frequently, you should try to find the reason why. For an explanation of how MyISAM tables can become corrupted, see Section 18.2.4, “MyISAM Table Problems”. If you run mysqld with external locking disabled (which ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
Note that mysqlbinlog returns a suitable error if you attempt to read an encrypted binary log file directly, but older versions of mysqlbinlog do not recognise the file as a binary log file at all. The other option values are intended only for ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the query ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Parameters in_action ENUM('snapshot', 'overall', 'delta', 'create_tmp', 'create_table', 'save', 'cleanup'): The action to take. The default is to make a snapshot of the current content of the Performance Schema events_statements_summary_by_digest ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-update-vector-store.html
To keep up with the changes and updates in the documents in your local directory, you must update the vector embeddings loaded in the vector store table on a regular basis. The examples in this topic use the vector store table demo_embeddings ...To ...
https://dev.mysql.com/doc/workbench/en/wb-eer-color-key.html
Color connection lines within EER diagrams provide quick visual information about how the tables in your model relate. The following table defines the meaning of each color and indicates how you can open the underlying table information from your ...Existing connection lines are highlighted when you use a pointer device to hover on different database ...