PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
Although the expression can be a subquery, it must return a single column and at most a single row. The two have very different execution profiles and you should not expect them to take the same amount of time. Beginning with MySQL 8.0.34, this ...
https://dev.mysql.com/doc/refman/8.0/en/charset-configuration.html
The examples given here show what the setting might look like for Unix or Windows, respectively: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets [client] character-sets-dir="C:/Program Files/MySQL/MySQL Server 8.0/share/charsets" ...The collation must be a legal collation for the default character ...For Unicode character ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-memory-tables.html
Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional performance is worth the risk of losing data, or the overhead of copying data from a disk-based table at application ...
https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html
Clone permits cloning InnoDB data from a local or remote MySQL server instance. Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. The plugins supported by this interface include, but are not ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-security-procedures.html
Doing so means that potentially any file on the system can be read by MySQL, and thus—should MySQL be compromised—by an attacker. Note Many of the NDB Cluster utilities such as ndb_show_tables, ndb_desc, and ndb_select_all also work without ...
https://dev.mysql.com/doc/refman/8.0/en/charset.html
The default MySQL server character set and collation are utf8mb4 and utf8mb4_0900_ai_ci, but you can specify character sets at the server, database, table, column, and string literal levels. To maximize interoperability and future-proofing of your ... MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html
MySQL 8.0 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. For new installations, the sys schema is installed by default during data directory initialization if you use ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
For example, to achieve best results when using BETWEEN with date or time values, use CAST() to explicitly convert the values to the desired data type. To prevent this from happening, quote the value, as shown here: mysql> SELECT * FROM t1 WHERE c3 ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/8.0/en/reset-persist.html
RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. If the variable is not present in the file, an error occurs. For more ...Prior ...