Search Results
https://dev.mysql.com/doc/refman/9.7/en/faqs-innodb-change-buffer.html
How much space does InnoDB use for the change buffer? Prior to the introduction of the innodb_change_buffer_max_size configuration option in MySQL 5.6, the maximum size of the on-disk change buffer in the system tablespace was 1/3 of the InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-user-attributes-table.html
The access control system has not been initialized (for example, the server was started with the --skip-grant-tables option). The currently authenticated account has the UPDATE or SELECT privilege for the mysql.user system table. The currently ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-threadstat.html
The values of the os_ru_utime, os_ru_stime, os_ru_minflt, os_ru_majflt, os_ru_nvcsw, and os_ru_nivcsw columns are obtained using the system getrusage() call, or the equivalent. The MySQL Server's Event Scheduler can be employed to automate such ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-cloud-options.html
See Section 4.3.1.3, “Backing Up to Cloud Storage”, and Section 5.2, “Restoring a Backup from Cloud Storage to a MySQL Server”, for more information and instructions on using cloud storage with MySQL Enterprise Backup. --cloud-ca-path=PATH ... These options are for using cloud storage for single-file ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-compression-options.html
Thus we do not recommend this for active systems, but only for off-hour or inactive database servers, or where I/O rates are extremely low. When a backup is not created in a file system (for example, when cloud storage is used to save the backup), ... For an overview on backup compression, see Section 4.3.4, “Making a Compressed ...
https://dev.mysql.com/doc/relnotes/mysql-shell/9.7/en/news-9-2-0.html
(Bug #37154456) The util.checkForServerUpgrade check, routineSyntax is renamed to syntax and now uses the SQL version of the target server for the syntax checks. As of this release, if locking the MySQL system tables fails with an Access Denied ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Variable-sized pages: These store variable-sized parts for rows in the fragment. Every row having one or more variable-sized, one or more dynamic columns (or both) has a variable-sized part. The row may also contain one or more variable-size part ...
https://dev.mysql.com/doc/refman/9.7/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
After tables are loaded into MySQL HeatWave, data changes are automatically propagated from DB System tables to their counterpart tables in the MySQL HeatWave Cluster. DML operations, INSERT, UPDATE, and DELETE, on the DB System do not wait for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
Do not create Lakehouse tables on the source DB in a replicated DB System if any of the replicas are outside MySQL HeatWave on OCI or MySQL HeatWave on AWS. Before MySQL 8.4.0-u2, a replication channel might fail if a MySQL HeatWave Cluster is added ... MySQL HeatWave Lakehouse has the following limitations for all file ...