Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or replication. (Bug #11754117, Bug #45670) This ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.usage.html
Table 20.1 List of All Options Option Name Description --backup-dir The directory to store the backup data. --backup_innodb_data_file_path Specifies Innodb system tablespace files' path and size in backup. --backup_innodb_data_home_dir Backup base ... The following sections describe the command-line options for the different modes of operation of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/trouble.logging.html
Besides the message output of MySQL Enterprise Backup to the stderr stream and the log file, progress and history of each backup are also logged into the mysql.backup_progress and mysql.backup_history tables on the backed-up servers (to skip ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-missing.html
To cause MySQL NDB Cluster data to be distributed to any such excluded or skipped nodes following a partial restore, it is necessary to redistribute the data manually by executing an ALTER ONLINE TABLE ... REORGANIZE PARTITION statement in the mysql ... It is possible using MySQL Cluster Manager to perform a partial restore of a MySQL NDB Cluster—that is, to restore from a backup in which backup images from one or more data nodes are not ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
If any characteristics apply that cannot be passed to START TRANSACTION, such as ISOLATION LEVEL, a suitable SET TRANSACTION statement is prepended (for example, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; START TRANSACTION READ WRITE;). If a ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is next executed. Using prepared statements with placeholders for parameter values has the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
To Run Batch Queries, add the natural-language queries to a column in a new or existing table. This progress has led to improvements in areas such as image recognition, natural language processing, and predictive analytics, making AI more intuitive ... The following sections in this topic describe how to generate new text-based content using MySQL HeatWave GenAI: Before You Begin Generate Content Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
You can use this routine for generating and running SQL queries only for databases and tables that you have access to. @output: output parameter that includes the list of tables and databases considered for generating the SQL query, Model ID of the ...The routine also runs the generated SQL statement and displays the result ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-metrics.html
Metrics: Table 17-1 list the metrics for monitoring your DB Systems and MySQL HeatWave Clusters. Table 17-1 CloudWatch Metrics for MySQL HeatWave on AWS Metric Unit Description Dimensions Monitoring Configuration Templates the Metric Is In ...