PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-prerequisites.html
Enabling all the instruments and consumers just mentioned has a performance impact, so it is preferable to enable only the additional configuration you need. Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
Configuration changes made by updating this table persist across client sessions and server restarts. set_time The timestamp of the most recent modification to the row. (For example, the variable corresponding to the diagnostics.include_raw option ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
See Section 7.1.12.3, “DNS Lookups and the Host Cache”, and Section 29.12.21.3, “The host_cache Table”. It takes more than connect_timeout seconds to obtain a connect packet. If a client successfully connects but later disconnects improperly ... If connection problems occur such as communication errors or aborted connections, use these sources of information to diagnose problems: The error ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range queries. Multiple get Operations The ability to fetch multiple key-value pairs in a single memcached query ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...Adding an AUTO_INCREMENT column to a table with ALTER TABLE might not produce the same ordering of the rows on the replica and the ...(Bug #45677) An INSERT into a table that has a composite primary key that ...
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
The proper procedure depends on whether the character set is simple or complex: If the character set does not need special string collating routines for sorting and does not need multibyte character support, it is simple. For example, greek and swe7 ... This section discusses the procedure for adding a character set to ...
https://dev.mysql.com/doc/refman/8.0/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes take place) writes updates and changes as “events” to the binary ...Replicas are configured to read the binary log from the source and to execute the events in the binary log on the replica's local ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. This is ...For a supplementary character, utf16 has a special sequence for representing the character using 32 ...
https://dev.mysql.com/doc/refman/8.0/en/create-database.html
An error occurs if the database exists and you did not specify IF NOT EXISTS. For information about character set and collation names, see Chapter 12, Character Sets, Collations, Unicode. To see the available character sets and collations, use the ... CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ...
https://dev.mysql.com/doc/refman/8.0/en/example-foreign-keys.html
When an operation affects a key value in the parent table that has matching rows in the child table, the result depends on the referential action specified by ON UPDATE and ON DELETE subclauses of the FOREIGN KEY clause. Omitting ON DELETE and ON ...