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/uln-installation.html
If you are changing your package source to use ULN and not changing which build of MySQL you are using, then back up your data, remove your existing binaries, and replace them with those from ULN. If a change of build is involved, we recommend the ...One of the methods, covered in this section, is installing from Oracle's Unbreakable Linux Network ... Linux supports a ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...An event type ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-system-definition.html
Except when using NDB Cluster with MySQL Enterprise Monitor, is not necessary to have a [system] section in the config.ini file. The [system] section is used for parameters applying to the cluster as a whole. The Name system parameter is used with ...Name Version (or later) NDB 8.0.13 Type or units string Default [...] Range ...
https://dev.mysql.com/doc/refman/8.0/en/cleartext-pluggable-authentication.html
Table 8.19 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...Note ...
https://dev.mysql.com/doc/refman/8.0/en/multibyte-characters.html
If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character functions in the ctype-MYSET.c source file in the strings directory. Look at the ctype-*.c files in the strings ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-runtime-configuration.html
If there are Performance Schema configuration changes that must be made at runtime using SQL statements and you would like these changes to take effect each time the server starts, put the statements in a file and start the server with the init_file ...Put the statements for each monitoring configuration into their own file and specify the appropriate file as the init_file value when you start the ...
https://dev.mysql.com/doc/refman/8.0/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET MASTER Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. Also resets the relay log ...reset_option: { MASTER | REPLICA | SLAVE } The RESET statement is used to clear the state of various server ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
You must therefore upgrade all of the replicas in a replication topology to the target MySQL Server release, before you upgrade the source server to the target release. If you need to downgrade the servers in a replication topology, the source must ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
Thus, if an ER_UPDATE_TABLE_USED error occurs for a view reference that uses an expression equivalent to the subquery, adding ALGORITHM=TEMPTABLE to the view definition prevents merging and takes precedence over the derived_merge value. If such an ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
Also, with the replica's connection metadata repository and applier metadata repository stored in InnoDB tables, which became the default in MySQL 8.0, the internal state of the data engine transaction is changed following a filtered XA transaction, ... XA transaction support is limited to the InnoDB storage ...For “Internal XA”, storage engines ...For ...