Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/creating-documents.html
You store documents by passing a JSON data structure to the Collection.add() function. Some languages have direct support for JSON data, others have an equivalent syntax to represent that data. For strictly-typed languages it is possible to create ...MySQL Connectors that implement X DevAPI aim to implement support for all JSON methods that are native to the Connectors' specific ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-set-local-infile-handler.html
void mysql_set_local_infile_handler(MYSQL *mysql, int (*local_infile_init)(void **, const char *, void *), int (*local_infile_read)(void *, char *, unsigned int), void (*local_infile_end)(void *), int (*local_infile_error)(void *, char*, unsigned ...This is called once to do any setup necessary, open the data file, allocate data structures, and so ...You can ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
When notified by FOR EXPORT, InnoDB writes to disk certain kinds of data that is normally held in memory or in separate disk buffers outside the tablespace files. For each table, InnoDB also produces a file named table_name.cfg in the same database ...FLUSH ERROR LOGS Closes and reopens any error log file to which the server is ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | ...
https://dev.mysql.com/doc/internals/en/debug-sync-activation-deactivation.html
For test cases that require the Debug Sync facility, include the following line in the test case file: --source include/have_debug_sync.inc . The Debug Sync facility is an optional part of the MySQL server. The Debug Sync Facility, when compiled ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
You cannot use the group_replication_clone_threshold system variable to deactivate cloning when the required transactions are not available in any member's binary log files, because in that situation cloning is the only alternative to transferring ...To use cloning, at least one existing group member and the joining member must be set up beforehand to support remote cloning ... If you want to use remote cloning ...
https://dev.mysql.com/doc/refman/8.4/en/serialized-dictionary-information.html
For example, if the data dictionary becomes unavailable, object metadata can be extracted directly from InnoDB tablespace files using the ibd2sdi tool. For partitioned InnoDB tables comprised of multiple tablespaces, SDI data is stored in the ... In ...SDI data is updated by DDL operations on a table or CHECK TABLE FOR ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
The first thing we must do is create transaction manager to manage the data source and a specification of what transaction properties are required for the dao methods. To use transactional database access, we will need to change the storage engine ... Spring allows us to add transactions into our code without having to deal directly with the JDBC ...For that purpose, Spring provides a transaction management package that not only replaces JDBC ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-firewall.html
Configure the MySQL server configuration file to enable MySQL Enterprise Firewall at startup. You can edit the MySQL configuration file with an external editor or use MySQL Workbench to edit it. Add From File prompts for a firewall rules text file ...Setup and Configuration MySQL Workbench can manage the MySQL Enterprise Firewall installation and configuration by installing (or uninstalling) and enabling (or disabling) the plugin, and enabling (or disabling) Firewall ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-bulk-ingest-limitations.html
Bulk Ingest Limitations 7.2.2.3 Bulk Ingest Limitations The following are some limitations to the Bulk Ingest Feature of MySQL HeatWave on AWS when using the LOAD DATA FROM S3 statement with ALGORITHM=BULK: The target table must be empty. The ...If ...The state of the table should be as though it has been freshly ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
Let S be a logged statement that does not have an implicit commit, except CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT, UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA INFILE, and BINLOG. (Note: if ...