Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-howto-slaveinit.html
To do this, on the replica, execute the following CHANGE REPLICATION SOURCE TO statement, replacing the option values with the actual values relevant to your system: mysql> CHANGE REPLICATION SOURCE TO -> SOURCE_HOST='source_host_name', -> ... To ...
https://dev.mysql.com/doc/refman/9.7/en/set-default-role.html
For each user named immediately after the TO keyword, this statement defines which roles become active when the user connects to the server and authenticates, or when the user executes the SET ROLE DEFAULT statement during a session. SET DEFAULT ...
https://dev.mysql.com/doc/refman/9.7/en/show-table-status.html
For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. Timestamps are not persisted when the server is restarted or when the table is evicted from the InnoDB data dictionary cache. SHOW TABLE ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace-format.html
The following span types are emitted by the telemetry component: Control Span Session Span Statement Span Control Span Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-commands-single-file.html
Specify a --backup-image value of - (standard output) to stream an existing backup directory structure to a tape device or a command that transfers the backup to another server. If the image contains some entries with absolute pathnames, those ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-prep-storage.html
Choose in advance for this directory a location on a file system with sufficient storage; it could even be remotely mounted from a different server. Most mysqlbackup operations, including those on single-file backups, write data or metadata to a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.full.html
Most backup strategies start with a complete backup of the MySQL server, from which you can restore all databases and tables. In cases where database backups are moving from a faster disk system where the active database files sit to a possibly ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-installation.html
System Requirements MySQL Router supports the same platforms as MySQL Server, as listed here: https://www.mysql.com/support/supportedplatforms/database.html Hardware: Minimum requirement is 1 CPU Core and 256 MB of RAM. This chapter describes how ...
https://dev.mysql.com/doc/relnotes/mysql-enterprise-backup/9.7/en/news-9-5-0.html
Bugs Fixed Incremental backups could fail validation if multiple system tablespaces are present. Note These release notes were created with the assistance of MySQL HeatWave GenAI. MySQL Enterprise Backup 9.5.0 is the latest Innovation Release for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
Supported Encoding Types MySQL HeatWave supports Variable-length encoding(VARLEN) and Dictionary encoding (SORTED). The following table provides an overview of encoding type characteristics: Table 5.15 Column Encoding Type Characteristics Encoding ... This topic describes how to encode string columns to improve the performance of queries that access ...