Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
If autocommit mode is disabled within a session with SET autocommit = 0, the session always has a transaction open. If autocommit mode is enabled, each SQL statement forms a single transaction on its own. If a session that has autocommit disabled ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha2user -p Enter password: password For this connection attempt by sha2user, the server determines that caching_sha2_password is the appropriate authentication plugin and invokes it (because that was the ...Installing SHA-2 Pluggable Authentication The caching_sha2_password plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading ... MySQL provides two authentication plugins that implement ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by default), MySQL rejects queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-transid-mysql-connection-map: Enable or disable ndb_transid_mysql_connection_map plugin; that is, enable or disable INFORMATION_SCHEMA table having that name. ndb_read_backup: Enable read from any replica for all NDB tables; use ... The ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert. To disable autocommit during your import operation, surround it with SET autocommit and COMMIT statements: SET autocommit=0; ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Using this option, you can disable, for example, the deprecated mysql_native_password plugin at server startup. (Specifying the option as --plugin_name without a value has the same effect.) If the plugin fails to initialize, the server runs with the ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-transid-mysql-connection-map: Enable or disable ndb_transid_mysql_connection_map plugin; that is, enable or disable INFORMATION_SCHEMA table having that name. ndb_read_backup: Enable read from any replica for all NDB tables; use ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE EVENT. To disable myevent, use this ALTER EVENT statement: ALTER EVENT myevent DISABLE; The ON ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
Setting this parameter to 0 disables multithreaded building of ordered indexes. EnablePartialLcp: Enable partial LCP (true); if this is disabled (false), all LCPs write full checkpoints. LockPagesInMainMemory: 0=disable locking, 1=lock after memory ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
Setting this parameter to 0 disables multithreaded building of ordered indexes. EnablePartialLcp: Enable partial LCP (true); if this is disabled (false), all LCPs write full checkpoints. LockPagesInMainMemory: 0=disable locking, 1=lock after memory ... ApiFailureHandlingTimeout: Maximum time for API node failure handling before ...