Search Results
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. Its value is constructed from the User and Host columns of the user table row for the account. However, this value does not necessarily ...
https://dev.mysql.com/doc/refman/8.4/en/charset-cp932.html
The table shown at https://msdn.microsoft.com/en-us/goglobal/cc305152.aspx provides information about the Unicode values of cp932 characters. For cp932 table entries with characters under which a four-digit number appears, the number represents the ... Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
The tablespace_definition_cache option sets a limit for the number of tablespace definition objects that can be stored in the dictionary object cache. The table definition cache partition exists in parallel with the table definition cache that is ...
https://dev.mysql.com/doc/refman/8.4/en/help.html
Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, “Server-Side Help Support”). The HELP statement searches the help tables for the given search string and ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: mysql> INSERT INTO geo VALUES(@point3); ERROR 3819 (HY000): Check constraint 'geo_chk_1' is violated. MySQL supports validation ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mysqld.html
(We often refer to a mysqld process running in this manner as an SQL node.) It is fully aware of all cluster data nodes as well as their status, and establishes connections to all data nodes. If mysqld is started with only the --ndbcluster option, ...To be used with NDB Cluster, mysqld needs to be built with support for the NDB storage engine, as it is in the precompiled binaries available from ...
https://dev.mysql.com/doc/refman/8.4/en/no-login-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). The mysql_no_login server-side authentication plugin prevents all client ...
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
The replication_applier_configuration Performance Schema table contains the DESIRED_DELAY column which shows the delay configured using the SOURCE_DELAY option. The replication_applier_status Performance Schema table contains the REMAINING_DELAY ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-if-not-exists.html
Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, whether or not the table already exists on the source. SELECT follows somewhat different rules; see Section 19.5.1.7, “Replication of CREATE TABLE ... IF NOT ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-views.html
Views are filtered by their own name, not by the tables they refer to. This means that a view can be replicated to the replica even if the view contains a table that would normally be filtered out by replication-ignore-table rules. Care should ...