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/adding-collation-simple-8bit.html
This section describes how to add a simple collation for an 8-bit character set by writing the <collation> elements associated with a <charset> character set description in the MySQL Index.xml file. These files are located in the directory named by ...The example adds a collation named latin1_test_ci to the latin1 character ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-ssl-for-recovery.html
group_replication_recovery_ssl_ca: The path name of the Certificate Authority (CA) file to use for distributed recovery connections. group_replication_recovery_ssl_capath: The path name of a directory that contains trusted SSL certificate authority ... Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied not just to distributed recovery connections, but to group communications between members in ...
https://dev.mysql.com/doc/refman/8.0/en/string-collating.html
If the sorting rules for your language are too complex to be handled with simple arrays, you must define string collating functions in the ctype-MYSET.c source file in the strings directory. For a simple character set named MYSET, sorting rules are ...The existing character sets provide the best documentation and examples to show how these functions are ...
https://dev.mysql.com/doc/refman/8.0/en/using-gdb-on-mysqld.html
Use the --gdb option to mysqld to install an interrupt handler for SIGINT (needed to stop mysqld with ^C to set breakpoints) and disable stack tracing and core file handling. In most cases just using --thread_cache_size=5' helps a lot! If you want ...With some older gdb versions on Linux you must use run --one-thread if you want to be able to debug mysqld ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If column aliases are not used, or if they are the same as the column names, they must be distinguished using the row alias in the ON DUPLICATE KEY UPDATE clause. Column aliases must be unique with regard to the row alias to which they apply (that ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
If an X or Y coordinate argument is provided and the value is -inf, +inf, or NaN, an ER_DATA_OUT_OF_RANGE error occurs. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If a longitude or ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
This is shown in the following example statements: CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE = ('db1.old%'); CHANGE REPLICATION FILTER REPLICATE_WILD_IGNORE_TABLE = ('db1.new%', 'db2.new%'); Values used with REPLICATE_REWRITE_DB represent ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html
A GTID transaction can be addressed either by its GTID, or by the name of the file in which it is logged and its position within that file. Before setting the replication mode of an online server, it is important to understand some key concepts of ...An anonymous transaction has no GTID; MySQL 8.0 ensures that every anonymous transaction in a log is preceded by an ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-user-credentials.html
You must therefore set up a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. The same replication user must be used for distributed recovery on every group member.
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
Special characters in database and table names are encoded in the corresponding file system names as described in Section 11.2.4, “Mapping of Identifiers to File Names”. Certain objects within MySQL, including database, table, index, column, ...