Search Results
https://dev.mysql.com/doc/refman/9.7/en/encryption-functions.html
These functions support the use of a key derivation function (KDF) to create a cryptographically strong secret key from the information passed in key_str. The derived key is used to encrypt and decrypt the data, and it remains in the MySQL Server ...
https://dev.mysql.com/doc/refman/9.7/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-auto-increment-handling.html
InnoDB follows the same procedure when initializing the auto-increment counter for a newly created table that has a user-specified auto-increment value greater than 0. To make this clear, consider an example that uses this table: CREATE TABLE t1 ( ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/9.7/en/lock-instance-for-backup.html
LOCK INSTANCE FOR BACKUP permits DDL operations that only affect user-created temporary tables. In effect, files that belong to user-created temporary tables can be created, renamed, or removed while a backup lock is held. The BACKUP_ADMIN privilege ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while preventing operations that could result in an inconsistent ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. By ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-optimization.html
To see whether a given Performance Schema table has indexes and what they are, use SHOW INDEX or SHOW CREATE TABLE: mysql> SHOW INDEX FROM performance_schema.accounts\G *************************** 1. row *************************** Table: accounts ... Applications that monitor databases may make frequent use of Performance Schema ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-cloud-service-configuration-s3api.html
AWS_ACCESS_KEY_ID: Specifies an AWS access key associated with an IAM user or role. Configuration Files MySQL Shell requires the following parameters in one or more configuration files: aws_access_key_id: specifies the access key associated with the ... MySQL Shell S3 support has been tested against the following S3-compatible storage services: Amazon Web Services S3 See Amazon Simple Storage Service Documentation for more ...
https://dev.mysql.com/doc/ndb-operator/9.7/en/crd-ndbmysqldspec.html
If unspecified, a secret is created by the operator with a generated name in the format ndb_resource_name-mysqld-root-password. rootHost (string): (optional) Names the host or hosts from which the root user can connect to the MySQL server. If ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-genai-update-vector-store.html
To test the steps in this topic, download and place the MySQL AI user guide PDF in the folder demo-directory that you created earlier for storing files to ingest into the vector store. The examples in this topic use the vector store table ... To ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
On Windows x64 editions, use the ODBC administration tool located at %SystemRoot%\SysWOW64\odbcad32.exe, this will correctly locate the installed Connector/ODBC drivers and enable you to create a Connector/ODBC DSN. A simple example can be found ...