Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-change-optimization.html
This section explains how to speed up data change statements: INSERT, UPDATE, and DELETE. For inserting and updating large volumes of data (known in the industry as ETL, for “extract-transform-load”), sometimes you use other SQL statements or ...Traditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
Persisting Data and Configuration Changes Docker containers are in principle ephemeral, and any data or configuration are expected to be lost if the container is deleted or corrupted (see discussions here). A MySQL Docker installation is different ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
CRUD Operations The four basic operations that can be issued against a collection are Create, Read, Update and Delete (CRUD). In terms of MySQL this means: Create a new document (insertion or addition) Read one or more documents (queries) Update one ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. If you use DROP DATABASE on a symbolically linked database, both the link and the original database are deleted. Be very careful ...
https://dev.mysql.com/doc/refman/8.4/en/error-creating-innodb.html
Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all redo log files (#ib_redoN files). If you created any InnoDB tables, also ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a DML or DDL statement fails due to problems at the file system ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
The EVENT privilege governs the creation, modification, and deletion of events. In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
Extended information is available for SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). The EXPLAIN statement produces extra ...
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
Internally, the implementation uses SELECT, INSERT, UPDATE, and DELETE, but not HANDLER. The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE, and indexes. The following items indicate features that the FEDERATED ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
Space is not released back to the operating system as it is when a file-per-table tablespace is deleted during a DROP TABLE operation. A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server ...