PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/examples.html
Supposing that each trader has a single fixed price per article, then (article, dealer) is a primary key for the records. Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
ref is used if the join uses only a leftmost prefix of the key or if the key is not a PRIMARY KEY or UNIQUE index (in other words, if the join cannot select a single row based on the key value). To fix this disparity between column lengths, use ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-thread-pool.html
Unlike the default connection handling of the MySQL Server, the Thread Pool separates connections and threads, so there is no fixed relationship between connections and the threads that execute statements received from those connections. What is the ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...