Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
This data is available in the slow query log for qualifying queries, and in the context of the audit log it similarly helps to detect outliers for activity analysis. This section describes how to configure audit logging characteristics, such as the ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
The InnoDB buffer pool caches both table data and index data, speeding up lookups for queries and keeping query results in memory for reuse. autocommit=1 is suitable for InnoDB tables when running a sequence of queries for generating reports or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. LOCK clauses are described below, in ...Reduced locking and waiting for MySQL server resources leads to greater scalability, even for operations that are not involved in the DDL ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
For example: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost'; ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90; From the mysql ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
This may slow down the server if the output is suspended. mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
Boolean queries against a MyISAM search index can work even without a FULLTEXT index, although a search executed in this fashion would be quite slow. InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
Queries appear in the slow query log that did not appear there previously. If an index made invisible actually is needed or used by the optimizer, there are several ways to notice the effect of its absence on queries for the table: Errors occur for ... MySQL supports invisible indexes; that is, indexes that are not used by the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-store-overview.html
GenAI encodes your queries using the same embedding model that is used to encode the ingested data to create the vector store. About Accelerated Processing of Queries on Vector-Based Tables GenAI lets you run queries on tables that contain vector ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
However, it is also the slowest choice (unless the disk has a battery-backed cache, which makes synchronization very fast). InnoDB Transaction Logs Not Sized Correctly Description To avoid frequent checkpoint activity and reduce overall physical ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
Increasing innodb_stats_persistent_sample_pages too much, however, could cause ANALYZE TABLE to run slowly. The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server ...