Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-redo-log.html
Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable. The Innodb_redo_log_capacity_resized server status variable indicates the total redo log capacity for all redo log files. Redo ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/9.7/en/memory-use.html
You can improve MySQL performance by increasing the values of certain cache and buffer-related system variables. The size of the buffer pool is important for system performance: InnoDB allocates memory for the entire buffer pool at server startup, ...The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
If the source server contains data, import existing data into the DB System: Export the data from the MySQL source server (see Exporting Data Using MySQL Shell for instructions) and: If using GTID-based replication: Capture the value of the source ...Replication positioning: Configure the Source GTID settings: Use GTID auto-positioning : Select this option when the system variable, gtid_mode, is set to ON on the ... Creating ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
(See Section 7.1.8, “Server System Variables”.) If you want all your tables to be able to grow above the default limit and are willing to have your tables slightly slower and larger than necessary, you can increase the default pointer size by ...
https://dev.mysql.com/doc/connectors/en/connector-net-versions.html
MySQL Connector/NET 9.x series is a continuation of Connector/NET 8.x series, but now named to synchronize with the (latest) MySQL server version it supports. For general guidance about configuring the server and clients for secure connections, see ...This version continues the functionality of the previous Connector/NET release series, including support for X Protocol ...
https://dev.mysql.com/doc/refman/9.7/en/replication-upgrade.html
When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to replication. For general information and instructions for upgrading a MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-logging-configuration.html
Naming Conventions for Audit Log Files To configure the audit log file name, set the audit_log.file system variable at server startup. If you want to stop collecting the query statistics, use the audit_log_filter_set_filter() audit log function to ...A flush task configured using the audit_log.flush_interval_seconds system variable has a value of zero by default, which means the task is not scheduled to ... This section describes how to configure audit logging characteristics, such as ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/upgrade-innodb-replicaset.html
On a Unix system, if you used the optional --directory bootstrap option, a self-contained installation is created with all generated directories and files at the location you selected when you bootstrapped the router. Navigate to this directory and ... To upgrade the instances in an InnoDB ReplicaSet, complete the following steps: Upgrade MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-group-membership.html
However, if the group is not able to reach agreement, for example because it partitioned in such a way that there is no majority of servers online, the system is not able to dynamically change the configuration, and blocks to prevent a split-brain ... In MySQL Group Replication, a set of servers forms a replication ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-dump-instance-schema.html
The exported items can then be imported into a MySQL HeatWave Service DB System or a MySQL Server instance using the util.loadDump() utility (see Section 12.6, “Dump Loading Utility”). The size of these columns therefore must not exceed ...When ... MySQL Shell's instance dump utility util.dumpInstance() and schema dump utility util.dumpSchemas(), support the export of all schemas or a selected schema from an on-premise MySQL instance into an Oracle Cloud Infrastructure Object Storage bucket or a set of local ...