Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/result-set-classes.html
SqlResult session.sql().execute() Number of rows affected by the operation, auto generated document IDs, last auto- generated AUTO INCREMENT column values, warnings, or fetched data set, depending on the operation for which SqlResult is returned.
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/8.4/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/heatwave/en/mys-hw-advisor-syntax.html
Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. auto_enc: Defines settings for Auto Encoding, see Section 5.8.4, “Auto Encoding”. auto_dp: Defines settings for Data Placement, which recommends data ...The silent output type is useful if human-readable output is not required; when the output is consumed by a script, for ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a persisted system variable causes the variable no longer to be ...The ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...In addition, if the explicit_defaults_for_timestamp system variable is disabled, you can initialize or update any TIMESTAMP (but not DATETIME) column to the current date and time by assigning it a NULL value, unless it has been defined with the NULL attribute to permit NULL ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/mysql-enterprise-backup/8.4/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 ...