Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
Issuing multiple GRANT statements containing wildcards may not have the expected effect on DML statements; when resolving grants involving wildcards, MySQL takes only the first matching grant into consideration. When the AS user clause is specified, ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
The optimizer takes into account the primary key columns of the extended secondary index when determining how and whether to use that index. row *************************** id: 1 select_type: SIMPLE table: t1 type: ref possible_keys: PRIMARY,k_d ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
The pages are grouped into extents of size 1MB for pages up to 16KB in size (64 consecutive 16KB pages, or 128 8KB pages, or 256 4KB pages). External off-page storage for variable-length columns differs by row format: COMPACT and REDUNDANT Row ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 0 MAX_COUNT: 0 MIN_COUNT: NULL AVG_COUNT: 0 COUNT_RESET: 0 MAX_COUNT_RESET: 0 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 TIME_DISABLED: NULL ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
This functionality is intended for loading data into a new MySQL instance. Warning This feature is intended only for loading data into a new MySQL instance. The following procedure demonstrates how to disable redo logging when loading data into a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
For other search conditions, InnoDB locks the index range scanned, using gap locks or next-key locks to block insertions by other sessions into the gaps covered by the range. Because gap locking is disabled, phantom row problems may occur, as other ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
Obtain and Unpack the Distribution Pick the directory under which you want to unpack the distribution and change location into it. Configure the Distribution Change location into the top-level directory of the unpacked distribution: $> cd ... To ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: mysql> INSERT INTO geo VALUES(@point3); ERROR 3819 (HY000): Check constraint 'geo_chk_1' is violated. MySQL supports validation ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL currently interprets the reference as the name of a variable. The scope of a local variable is the BEGIN ... The variable can be referred to in ...