PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.3Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
When REQUIRE_ROW_FORMAT is set, you must use row-based binary logging (binlog_format=ROW) on the source server. In MySQL 8.0.18, REQUIRE_ROW_FORMAT is not available, but the use of row-based binary logging for secured replication channels is still ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-examples.html
It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging format. With row-based format, DML statements are handled based on the database where the modified ...
https://dev.mysql.com/doc/refman/8.0/en/set.html
Normally, you search for SET values using the FIND_IN_SET() function or the LIKE operator: mysql> SELECT * FROM tbl_name WHERE FIND_IN_SET('value',set_col)>0; mysql> SELECT * FROM tbl_name WHERE set_col LIKE '%value%'; The first statement finds rows ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows. In ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-analysis.html
rows_sent The total number of rows returned by occurrences of the statement. rows_sent_avg The average number of rows returned per occurrence of the statement. rows_examined The total number of rows read from storage engines by occurrences of the ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...
https://dev.mysql.com/doc/refman/8.0/en/using-spatial-indexes.html
| +-----+---------------------------------------------------------------+ 20 rows in set (0.00 sec) Use EXPLAIN to check the way this query is executed: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 ...
https://dev.mysql.com/doc/refman/8.0/en/delete-optimization.html
To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete all ...Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
row *************************** SPACE: 4294967294 NAME: mysql SPACE_TYPE: General ENCRYPTION: Y *************************** 2. row *************************** SPACE: 2 NAME: test/t1 SPACE_TYPE: Single ENCRYPTION: Y *************************** 3. row ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
mysql> SELECT * FROM test.demo_test; +----+--------------+------+------+------+ | c1 | c2 | c3 | c4 | c5 | +----+--------------+------+------+------+ | AA | HELLO, HELLO | 8 | 0 | 0 | +----+--------------+------+------+------+ Remove all rows from ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...