Search Results
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD XML. By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
Once an event for an external file location is emitted due to a change to an object, Lakehouse automatically refreshes the data into the external table. Event-based incremental load automates the process of updating external tables based on changes ... As of MySQL 9.4.1, you can load data from Object Storage by using event-based incremental ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The preceding definition can be written like this: { "filter": { "class": [ { "name": [ "connection", "general", "table_access" ] } ] } } Logging Specific Event Subclasses To select specific event subclasses, use an event item containing a name item ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
(Bug #37075154) Removed an error in mysql_prepare_create_table() (in the file sql/sql_table.cc) found when compiling MySQL with XCode 16. Alternatively, you can drop and re-create such indexes immediately following the upgrade, but before making use ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database cache was not flushed properly following execution of DROP ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> ...Typically the first audit record written after plugin startup contains the server description and startup ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
This had an adverse effect on queries using joins on InnoDB tables. InnoDB: InnoDB did not allow updating a REDUNDANT table column that was altered with NULL as the default value using the INSTANT algorithm. (Bug #36341532) InnoDB: Redesigned the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
Even when the Performance Schema is disabled, it continues to populate the global_variables, session_variables, global_status, and session_status tables. This occurs as necessary to permit the results for the SHOW VARIABLES and SHOW STATUS ...The ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-3-0.html
The effected options and variables are listed here: --slave-rows-search-algorithms: The algorithm used by the replication applier to look up table rows when applying updates or deletes is now always HASH_SCAN,INDEX_SCAN, and is no longer ...(Bug ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. An exclusive metadata lock on the ...