Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-unexpected-replica-halt.html
The details of the recovery process are influenced by the chosen method of replication, whether the replica is single-threaded or multithreaded, and the setting of relevant system variables. The system variable itself is also deprecated, so omit it ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-create-table-external.html
For general information about setting system variables, see Section 7.1.9, “Using System Variables”. Tables are implicitly created in file-per-table tablespaces when the innodb_file_per_table variable is enabled, which it is by default. Known ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-maintenance-schedule.html
(These are “expected crashed tables.”) To cause the server to check MyISAM tables automatically, start it with the myisam_recover_options system variable set. You should also check your tables regularly during normal system operation. It is a ...
https://dev.mysql.com/doc/refman/9.7/en/commit.html
To disable autocommit mode for each new connection, see the description of the autocommit system variable at Section 7.1.8, “Server System Variables”. If the read_only system variable is enabled, explicitly starting a transaction with START ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-production-instances.html
For example: mysql-js> var myCluster = dba.dropMetadataSchema() Are you sure you want to remove the Metadata? [y/N]: y The MySQL instance at 'localhost:3310' currently has the super_read_only system variable set to protect it from inadvertent ...For ... AdminAPI provides the dba.configureInstance() function that checks if an instance is suitably configured for InnoDB Cluster usage, and configures the instance if it finds any settings which are not compatible with InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-index-stat.html
--connect-retry-delay Command-Line Format --connect-retry-delay=# Type Integer Default Value 5 Minimum Value 0 Maximum Value 5 Number of seconds to wait between attempts to contact management server. --ndb-mgm-tls Command-Line Format ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-start-stop-nodes.html
For example, disconnecting is required when stopping the management server to which the handle is connected. For example, disconnecting is required when stopping the management server to which the handle is connected. If initial is true (1), then ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-22.html
Deprecation and Removal Notes Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes The following synonyms for the Server connection string option were deprecated in Connector/NET 8.0.22 and removed in 8.0.23: address, addr, and ...(Bug #31248601) Functionality Added or Changed Revisions to the MySql.Data.EntityFrameworkCore namespace reduced the number of public ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Note: To map and load data into Lakehouse, the Amazon S3 bucket in which the data is located and the DB System must be in the same region. This task requires the following: A running DB system with an active MySQL HeatWave Cluster. Do the following ... Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process data in Amazon S3, it needs to first map the data in files on S3 to a MySQL HeatWave Lakehouse ...
https://dev.mysql.com/doc/refman/9.7/en/key-cache-restructuring.html
Instead, the server directly accesses the table indexes using native file system caching. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component ... A key cache can be restructured at any time by updating its parameter ...