Search Results
https://dev.mysql.com/doc/refman/8.4/en/features.html
An index may use a prefix of a column for CHAR, VARCHAR, BLOB, or TEXT column types. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
For example, if each server instance is on a different machine with a fixed network address, you could use the IP address of the machine, such as 10.0.0.1. This section explains the configuration settings required for MySQL Server instances that ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
The name of each Group Replication system variable is prefixed with group_replication_. You can use CIDR notation in combination with host names or IP addresses to permit a block of IP addresses with a particular network prefix, but you should ...
https://dev.mysql.com/doc/refman/8.4/en/ignoring-user.html
To fix this problem, assign a new, valid password to the account. If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. For additional information ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
Files are typically divided into fixed-size blocks that are compressed into variable-size blocks, which easily leads into fragmentation. The 768-byte prefix is followed by a 20-byte pointer to the overflow pages that contain the rest of the column ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-enabling-monitors.html
InnoDB sends the monitor output to stderr rather than to stdout or fixed-size memory buffers to avoid potential buffer overflows. When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-midpoint_insertion.html
The default value of innodb_old_blocks_pct is 37, corresponding to the original fixed ratio of 3/8. Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never ...