Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
A collection is a set of one or more columns included in a FULLTEXT index. To perform a case-sensitive full-text search, use a case-sensitive or binary collation for the indexed columns. The search must be performed using a full-text index scan ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
ALGORITHM=INPLACE can be used to perform online ADD COLUMN, ADD INDEX (including CREATE INDEX statements), and DROP INDEX operations on NDB tables. Online ALTER TABLE, CREATE INDEX, or DROP INDEX statements that add columns or add or drop indexes ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
This means that you can use the following SELECT statement to find rows into which invalid ENUM values were assigned: mysql> SELECT * FROM tbl_name WHERE enum_col=0; The index of the NULL value is NULL. and these potential issues to consider: If you ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-config-ui.html
QRTi Graph: adds a Query Response Time index pie-chart to the left side of the statement. Notices: Filters on the notices, enabling you to filter the list to show only the queries that did not raise a notice, indicated a full table scan, or ... The ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. The following discussion describes the structure of the diagnostics area in MySQL, the information items recognized by MySQL, how statements clear and set the ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Elements following that one represent events such as client connect and disconnect events, executed SQL statements, and so forth. Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. The ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is used. The binary log also contains information about how long each statement took that updated ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
In such cases queries may need to be tuned or rewritten, or indexes added to improve performance. In such cases queries may need to be tuned or rewritten, or indexes added to improve performance. Default frequency 06:00:00 Default auto-close enabled ...For optimal performance, transactions that move through the binary log should be contained within the binary log ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
To assign table indexes to a specific key cache, use the CACHE INDEX statement (see Section 15.7.8.2, “CACHE INDEX Statement”). The CACHE INDEX statement sets up an association between a table and a key cache, but the association is lost each ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, locking depends on whether the statement uses a unique index with a unique search condition, or a range-type search condition. For locking reads (SELECT with FOR ...A user can change the isolation level for a single session or for all subsequent connections with the SET TRANSACTION ...