Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based replication. For InnoDB: An INSERT statement that uses AUTO_INCREMENT blocks other nonconflicting INSERT statements.
https://dev.mysql.com/doc/x-devapi-userguide/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. Also, using column prefixes for indexes can make the ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
Since the user does not have the INSERT privilege for the table in question, the event has no effect. If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
INSERT BUFFER AND ADAPTIVE HASH INDEX This section shows the status of the InnoDB insert buffer (also referred to as the change buffer) and the adaptive hash index. The Lock Monitor is the same as the Standard Monitor except that it includes ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-logs.html
For example, a transaction that performs INSERT, UPDATE, and DELETE operations on regular and temporary tables requires a full assignment of four undo logs. A transaction that performs only INSERT operations on regular tables requires a single undo ... An undo log is a collection of undo log records associated with a single read-write ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Client 2: INSERT INTO x VALUES(1); The statement requests and blocks waiting for a write lock on x. Client 2 then acquires its lock on x, performs the insert, and releases its lock. Lock acquisition order results in the RENAME TABLE executing before ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
The permissible values are read (scan tables), write (insert into tables), key (read primary keys), update (update primary keys), or mixed (half inserts, half scanning selects). --auto-generate-sql-write-number=N Command-Line Format ... mysqlslap is ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
As with table partitioned by RANGE, you can use MAXVALUE to represent a value such that any legal value inserted into a given column is always less than this value. Placement of rows into partitions is determined by comparing the tuple from a row to ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...