Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.incremental.html
There are different ways to use incremental backups to restore a database server under different scenarios. Binary Log and Relay Log Restore When an incremental backup is being restored using either the copy-back-and-apply-log or ... Note The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
If you wish to make such information hidden from queries that select from these tables, you can do so by setting the value of the show_gipk_in_create_table_and_information_schema server system variable to OFF. INFORMATION_SCHEMA provides access to ...They are actually views, not base tables, so there are no files associated with them, and you cannot set triggers on ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
When the read_only system variable is enabled, SET PASSWORD requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege), in addition to any other required privileges. For accounts that use a plugin that performs authentication ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-asp-roles.html
This system is designed around the concept of membership, profile, and role providers, which together provide all of the functionality to implement a user system, that previously would have to have been created by the developer from scratch. It ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-asp-roles.html
This system is designed around the concept of membership, profile, and role providers, which together provide all of the functionality to implement a user system, that previously would have to have been created by the developer from scratch. It ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-cluster-failure-and-recovery.html
MySQL HeatWave data can be recovered from the MySQL HeatWave Storage Layer, or reloaded from the DB System and Amazon S3. To facilitate recovery, data is persisted to Storage Layer when data is loaded into the MySQL HeatWave Cluster and when data ...
https://dev.mysql.com/doc/refman/8.4/en/replication-formats.html
The logging format in a running MySQL server is controlled by setting the binlog_format server system variable. The rules governing when and how the new setting takes effect are the same as for other MySQL server system variables. To make the global ...Changing the global binlog_format value requires privileges sufficient to set global system ...Setting the variable for the current ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. Prepared statement scope is the current session, not the stored program, so the ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-in-core-file.html
mysql> SET GLOBAL innodb_buffer_pool_in_core_file=OFF; If the innodb_buffer_pool_in_core_file variable is disabled but MADV_DONTDUMP is not supported by the operating system, or an madvise() failure occurs, a warning is written to the MySQL server ...The innodb_buffer_pool_in_core_file option is only relevant if the core_file variable is enabled and the operating system supports the MADV_DONTDUMP non-POSIX extension to the madvise() system call, which is supported in Linux 3.4 and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
To avoid this interval when a direct query to the replica could return stale data, you can set the init_file system variable to name a file containing statements that populate the MEMORY table on the source at startup. (The method just described is ... When a replication source server shuts down and restarts, its MEMORY tables become ...To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be ...