Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-update-vector-store.html
The following sections in this topic describe how to update a vector store: Before You Begin Load Data Incrementally into the Vector Store Table Delete and Recreate the Vector Store What's Next Before You Begin Complete the steps to set up a vector ... To keep up with the changes and updates in the documents in your Object Storage, you must update the vector embeddings loaded in the vector store table on a regular ...
https://dev.mysql.com/doc/refman/9.7/en/backup-types.html
MySQL Enterprise Backup does this locking automatically for tables that require it. Full Versus Incremental Backups A full backup includes all data managed by a MySQL server at a given point in time. An incremental backup consists of the changes ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-1-0.html
This value is incremented by executing ADD COLUMN and DROP COLUMN operations using the INSTANT ALGORITHM. When the total amount of memory used by all queries exceeds this amount, this causes Count_hit_query_past_global_connection_memory_status_limit ...This could lead to the following issues: When CREATE DATABASE failed after the database directory was created but before the operation was actually committed, the data dictionary had no record of the database's existence, but the database directory was still present in the file system, necessitating manual ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-api-statistics.html
Includes all execute() calls as well as implicit executes for blob operations and auto-increment not visible to clients. This count includes blob-part table operations, implicit unlocking operations, and auto-increment operations, as well as primary ...The counters are incremented inside the NDB kernel whenever NDB API calls are made or data is sent to or received by the data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
Load this data into MySQL HeatWave as an aggregate table by using Auto Parallel Load. Update this table with new data loaded to the same bucket for new aggregates by using the incremental load feature. Note Code (3877) : Query results will be ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-locking.html
AUTO-INC Locks An AUTO-INC lock is a special table-level lock taken by transactions inserting into tables with AUTO_INCREMENT columns. It allows you to choose how to trade off between predictable sequences of auto-increment values and maximum ...A ...
https://dev.mysql.com/doc/x-devapi-userguide/en/parameter-binding.html
Instead of using values directly in an expression string it is good practice to separate values from the expression string. This is done using parameters in the expression string and the bind() function to bind values to the parameters. Parameters ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor-sql.html
Autopilot Shape Advisor with a MySQL Client 17.3.2 Autopilot Shape Advisor with a MySQL Client Auto Shape Prediction records predictions in the shape_predictions table in the mysql_autopilot schema on the MySQL server. This is a system schema that ...The schema also contains tables for the statistics used to calculate the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options.html
System Variable server_uuid Scope Global Dynamic No SET_VAR Hint Applies No Type String When starting, the MySQL server automatically obtains a UUID as follows: Attempt to read and use the UUID written in the file data_dir/auto.cnf (where data_dir ... The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/advanced.encrypted-binlog-relaylog.html
For a series of incremental backups, if a keyring plugin or component other than component_keyring_encrypted_file is being used on the server, users can provide a different value for --encrypt-password for any of the full or incremental backup in ...