Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
To force use of the COPY algorithm for an ALTER TABLE operation that would otherwise not use it, specify ALGORITHM=COPY or enable the old_alter_table system variable. For MyISAM tables, you can speed up index re-creation (the slowest part of the ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
Migration Wizard: Executes the database migration wizard for most any database, and is meant to migrate tables and data from supported database systems to your MySQL server. 9.1.1.1.6 The Database Menu This menu features actions against the ... Some ...
HeatWave on AWS :: 3.1.2.1.3 MySQL Versions Deprecation and Removal Policy in MySQL HeatWave Service
https://dev.mysql.com/doc/heatwave-aws/en/mysql-versions-deprecation.html
To update the MySQL Server version of a DB system, see Upgrade MySQL Version. When you are running a deprecated version of MySQL Server on your DB System, the MySQL version on the Details page of your DB System is marked with the Deprecated label.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
All SQL nodes acting as sources and replicas are started with the system variable log_replica_updates enabled. However, you must not start any of the SQL nodes with the log_replica_updates system variable enabled. This is equivalent to setting the ...Examples of incidents are server failures, database resynchronization, some software updates, and some hardware changes.) When the replica encounters a gap in the replication log, it stops with an error ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-priority-based-filtering.html
To affect how log_filter_internal permits or suppresses error, warning, and information events intended for the error log, set the log_error_verbosity and log_error_suppression_list system variables. The log_error_verbosity system variable controls ...log_error_verbosity Value Permitted Message Priorities 1 ERROR 2 ERROR, WARNING 3 ERROR, WARNING, INFORMATION If log_error_verbosity is 2 or greater, the server logs messages about statements that are unsafe for statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-starting.html
This can be accomplished by setting the system variable replica_allow_batching on the replicas' mysqld processes. Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 25.7.2, “General ... This section outlines the procedure for starting NDB Cluster replication using a single replication ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-ldap-sasl-kerberos.html
Also, the authentication_ldap_sasl_auth_method_name system variable must be set to use the GSSAPI method. For additional variables that can (or should) be configured when using the server-side plugin, see Configure the Server-Side SASL LDAP ... The ...Using the GSSAPI security abstraction interface, a connection of this type authenticates to Kerberos to obtain service credentials, then uses those credentials in turn to enable secure access to other ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-performance-extensions.html
Default Value true Since Version 3.1.7 maintainTimeStats Should the driver maintain various internal timers to enable idle time calculations as well as more verbose error messages when the connection to the server fails? Setting this property to ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
Default Value true Since Version 3.1.7 maintainTimeStats Should the driver maintain various internal timers to enable idle time calculations as well as more verbose error messages when the connection to the server fails? Setting this property to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
This section describes how to set up a MySQL server to use binary log file position based replication. Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in ...There are a number of different methods for setting up replication, and the exact method to use depends on how you are setting up replication, and whether you already have data in the database on the source that you want to ...