PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-message-fragmentation.html
From MySQL 8.0.16, by default, large messages are automatically split into fragments that are sent separately and reassembled by the recipients. In order for a replication group to use fragmentation, all group members must be at MySQL 8.0.16 or ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
Many users have lost time by not doing this soon enough after encountering problems. For example, the --skip-slave-start command line option, or from MySQL 8.0.24, the skip_slave_start system variable, prevents the replication threads from starting ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...This ...
https://dev.mysql.com/doc/refman/8.0/en/using-spatial-indexes.html
The following query finds all objects that are in the given rectangle: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 15000))'; mysql> SELECT fid,ST_AsText(g) FROM geom WHERE -> ... The optimizer ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. MySQL also supports nonaggregate functions that are used only as window functions. A MySQL ...However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. As of MySQL 8.0.33, the server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a ...A ...
https://dev.mysql.com/doc/refman/8.0/en/call.html
When the procedure returns, a client program can also obtain the number of rows affected for the final statement executed within the routine: At the SQL level, call the ROW_COUNT() function; from the C API, call the mysql_affected_rows() function.
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. The binary ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
For example, comparisons with SCHEMATA.SCHEMA_NAME match 'information_schema' or 'INFORMATION_SCHEMA' regardless of platform: mysql> SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'information_schema'; +--------------------+ ... String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is ...