Search Results
https://dev.mysql.com/doc/refman/8.4/en/call.html
Metadata changes to objects referred to by stored programs are detected and cause automatic reparsing of the affected statements when the program is next executed. CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set explicitly. performance_schema_accounts_size Command-Line Format --performance-schema-accounts-size=# System Variable ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
When the receiver thread is stopped, you can execute CHANGE REPLICATION SOURCE TO using any of the options for this statement (in any allowed combination) except RELAY_LOG_FILE, RELAY_LOG_POS, SOURCE_DELAY, or SOURCE_AUTO_POSITION = 1 even when the ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/8.4/en/option-files.html
A server started with the persisted_globals_load system variable disabled does not read mysqld-auto.cnf. Management of mysqld-auto.cnf should be left to the server and not performed manually. As used to find mysqld-auto.cnf, its default value is the ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
The Schedule subtab optionally sets a backup schedule for both full and incremental backups. A full backup is slower than the incremental backup that merges with a full backup. A common scenario is to set a full backup as weekly, and an incremental ... This section describes how to configure a backup profile that defines what should be backed up, where the backup should be stored, and when (the frequency) it should be backed ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
It is more efficient to make an initial full backup, and then to make incremental backups. The incremental backups are smaller and take less time to produce. You must also process the incremental backups to recover the incremental changes. To make ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Com_stmt_reprepare indicates the number of times statements were automatically reprepared by the server, for example, after metadata changes to tables or views referred to by the statement. Each invocation of the SHOW STATUS statement uses an ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
Full or Incremental Backup After taking a full backup, subsequent backups can be performed more quickly by doing incremental backups, where only the changed data is backed up. For an incremental backup, specify the --incremental or ... This section ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-cloud.html
All mysqlbackup options compatible with single-file operations (including, for example, the incremental, compression, partial, and encryption options) can be used with cloud backups or restores. mysqlbackup --defaults-file=/home/dbadmin/my.cnf ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
For other usage examples, see the discussion later in this section and in Section 9.5, “Point-in-Time (Incremental) Recovery”. When binary log transaction payloads have been compressed, mysqlbinlog automatically decompresses and decodes the ...