Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
In cases where a console is shared, this behavior may be unsuitable. Alternatively, create a shortcut that only sets the console font, and set the character set in the [mysql] group of your my.ini file: [mysql] default-character-set=utf8mb4 # or ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
This makes PERSIST_ONLY suitable for configuring read-only system variables that can be set only at server startup. The Performance Schema variables_info table contains information showing when and by which user each system variable was most ... The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
For example, you might need to create a nonexistent table before you can start the replica again. For nontransactional storage engines such as MyISAM, it is possible to have a statement that only partially updates a table and returns an error code.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure, except where an exception is specifically allowed (see Section 19.5.1.9, “Replication with Differing Table ...DROP PARTITION) that act directly on partitions in such cases might produce different results on the source and the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID. It is not possible to restrict the effects of these two variables to a single table; these variables control the behavior of all ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
The statement does not change the values of gtid_executed or gtid_purged, or the mysql.gtid_executed table. RESET REPLICA does not change any replication connection parameters, which include the source's host name and port, the replication user ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
The preceding query can also be written like this, using TABLE: SELECT (TABLE t2) FROM t1; A scalar subquery can be part of an expression, but remember the parentheses, even if the subquery is an operand that provides an argument for a function. For ... In its simplest form, a subquery is a scalar subquery that returns a single ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
Running mysqld as a Unix user other than root does not mean that you need to change the root user name in the user table. This includes the server's data directory containing the files that implement the privilege tables. INTO OUTFILE do not ...
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. By ...It ...