Search Results
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
rows_deleted Innodb_rows_deleted ASYNC COUNTER The number of rows inserted into InnoDB tables. system_rows_inserted Innodb_system_rows_inserted ASYNC COUNTER Number of rows inserted into InnoDB tables belonging to system-created schemas ...write ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #112478, Bug #35846847) An assertion failed in debug builds when inserting data with a zero-length column, such as CHAR(0) or BINARY(0), into a table. (Bug #36118772) Warnings for unused variables are turned into compilation errors when ...(Bug ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Figure 9.36 SQL Export Options The SQL Export Options displays the following facilities: Output SQL Script File: To specify the output file name, enter it into the Output SQL Script File field, or use the Browse button to select a file. Don't create ... Forward engineering enables you to create a script of your database ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
In our case we inserted 2 rows, but only the affected_rows of the last INSERT statement is returned as part of the OK_Packet. 01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In the following example, a document is passed as the final value to be inserted into the Info column. mysql-js> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with ... In MySQL, a table may contain traditional relational data, JSON values, or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-in-tables.html
In the following example, a document is passed as the final value to be inserted into the Info column. mysql-py> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with ... In MySQL, a table may contain traditional relational data, JSON values, or ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The check for v3 also fails: mysql> INSERT INTO v2 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v2' mysql> INSERT INTO v3 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v3' . The WITH CHECK OPTION clause can be given for an ...It also prevents updates to rows for which the WHERE clause is true but the update would cause it to be not true (in other words, it prevents visible rows from being updated to nonvisible ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #107991, Bug #34454572) Partitioning: When inserting NOW() into a column not part of the partition key of a partitioned table, all partitions were retrieved, and no pruning occurred. (Bug #37506554) In order to use xxhash functions ...(Bug ...