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/session-state-tracking.html
The tracker mechanism provides a means for MySQL connectors and client applications to determine whether any session context is available to permit session migration from one server to another. Notification occurs in the MySQL client/server ...A ...
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
You can control how long STOP REPLICA waits before timing out by setting the system variable rpl_stop_replica_timeout (from MySQL 8.0.26) or rpl_stop_slave_timeout (before MySQL 8.0.26). From MySQL 8.0.22, use STOP REPLICA in place of STOP SLAVE, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-main.html
On the source server, the output from SHOW PROCESSLIST looks like this: mysql> SHOW PROCESSLIST\G *************************** 1. row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has ... The SHOW PROCESSLIST statement provides information that tells you what is happening on the source and on the replica regarding ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-unicode-uca.html
This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml file. Table 12.4 MySQL Character Sets Available for User-Defined ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. One fix is to start mysqld with the --tmpdir ...The preceding error is a typical message for Windows; the Unix message is ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name ...
https://dev.mysql.com/doc/refman/8.0/en/charset.html
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 collations. The default MySQL server character set and collation are utf8mb4 and ...To maximize ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting transactions that can (and sometimes should) be used instead of sending a START TRANSACTION statement from the client. MySQL enables ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the statement. If you are using a nontransactional storage engine, MySQL stops processing the statement at the row for which the error occurred and leaves ... Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
The CREATE SERVER statement creates a new row in the servers table in the mysql database. The CREATE SERVER statement creates an entry in the mysql.servers table that can later be used with the CREATE TABLE statement when creating a FEDERATED table.