Search Results
https://dev.mysql.com/doc/refman/9.7/en/upgrade-paths.html
Notes Make sure you understand the MySQL release model for MySQL for MySQL long long-term support (LTS) and Innovation versions before proceeding with a downgrade. We recommend checking upgrade compatibility with MySQL Shell's Upgrade Checker ...
https://dev.mysql.com/doc/refman/9.7/en/validate-password-options-variables.html
This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. This applies only when changing an existing password, and has no effect when setting a user account's ...
https://dev.mysql.com/doc/refman/9.7/en/vector-functions.html
MySQL 9.7 supports SQL functions to work with VECTOR values. It accepts the following arguments: A column of VECTOR data type. STRING_TO_VECTOR(string) Converts a string representation of a vector to a binary one. The expected format of the string ...
https://dev.mysql.com/doc/refman/9.7/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/9.7/en/views.html
Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/9.7/en/windows-create-option-file.html
To initialize a MySQL installation by creating the data directory and populating the tables in the mysql system database, initialize MySQL using either --initialize or --initialize-insecure. If you need to specify startup options when you run the ...
https://dev.mysql.com/doc/refman/9.7/en/windows-select-server.html
The following table shows the available servers for Windows in MySQL 9.7. Binary Description mysqld Optimized binary with named-pipe support mysqld-debug Like mysqld, but compiled with full debugging and automatic memory allocation checking Each of ...
https://dev.mysql.com/doc/refman/9.7/en/windows-server-first-start.html
Note The initial root account in the MySQL grant tables has no password. This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/advanced.encrypted-binlog-relaylog.html
MySQL Enterprise Backup supports encrypted binary and relay logs, which are handled in a similar way as the encrypted InnoDB tables are (see Chapter 6, Working with Encrypted InnoDB Tablespaces for details). mysqlbackup then copies over from the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-commands-update.html
mysqlbackup [STD-OPTIONS] [--limit-memory=MB] [--uncompress] [--backup-dir=PATH] [MESSAGE-LOGGING-OPTIONS] [PROGRESS-REPORT-OPTIONS] [ENCRYPTED-INNODB-OPTIONS] apply-log apply-log Advanced: Brings the InnoDB tables in the directory backup ... There ...