PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table, ... Full-text searches are supported for InnoDB and MyISAM tables ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
This mode ensures that when a transaction is committed on the local member, any subsequent transaction reads the written value or a more recent value on any group member. Use this mode with a group that is used for predominantly read-only operations ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-events.html
Table 25.61 Events relating to NDB Cluster schema operations Event Priority Severity Level Description CreateSchemaObject 8 INFO Schema objected created AlterSchemaObject 8 INFO Schema object updated DropSchemaObject 8 INFO Schema object dropped ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgmd.html
Each time the management server updates its configuration data, it writes a new cache file. --interactive Command-Line Format --interactive Starts ndb_mgmd in interactive mode; that is, an ndb_mgm client session is started as soon as the management ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. With strict mode enabled, the warnings would become errors and terminate the INSERT. The ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
Please note the following: If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the table might be updated by the server during the packing process. If the mysqld server was invoked with ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If gtid_mode is either ON or ON_PERMISSIVE, the GTID column changes to the transaction's GTID. If gtid_mode is either ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. The following discussion describes how to write ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
In most cases, ALTER USER requires the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. To require an encrypted connection, a client need specify only the --ssl-mode=REQUIRED option; the connection attempt fails if ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
Cursors are read only; you cannot use a cursor to update rows. UPDATE WHERE CURRENT OF and DELETE WHERE CURRENT OF are not implemented, because updatable cursors are not supported. You cannot use a cursor for a statement that generates a result set ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...