Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
When you are ready to conduct long-term testing and put compressed tables into production, see Section 17.9.1.4, “Monitoring InnoDB Table Compression at Runtime” for ways to verify the effectiveness of those choices under real-world conditions.
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
The locks are normally next-key locks that also block inserts into the “gap” immediately before the record. For example, in a UNION, scanned (and locked) rows from a table might be inserted into a temporary table before evaluating whether they ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
If you insert a row into a table partitioned by RANGE such that the column value used to determine the partition is NULL, the row is inserted into the lowest partition. A row with a dt column value of NULL is treated as though the partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/populating-spatial-columns.html
For example: Inserting a POINT(1 1) value with hex literal syntax: INSERT INTO geom VALUES (ST_GeomFromWKB(X'0101000000000000000000F03F000000000000F03F')); An ODBC application can send a WKB representation, binding it to a placeholder using an ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-summary.html
In the case of a single-file backup, unpack the file into a backup directory structure using the extract or the image-to-backup-dir command to view the files. The database is put into a read-only state while these files are copied. The database is ... The following table shows the different types of files that are included in a single-file backup image or a directory ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-table-export.html
MySQL Shell's table export utility util.exportTable() exports a MySQL relational table into a data file, either on the local server or in an Oracle Cloud Infrastructure Object Storage bucket. The data can then be uploaded into a table on a target ...The data file can also be used to import data to a different application, or as a lightweight logical backup for a single data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
The adaptive hash index search system is partitioned into 8 parts by default. innodb_buffer_pool_instances Command-Line Format --innodb-buffer-pool-instances=# System Variable innodb_buffer_pool_instances Scope Global Dynamic No SET_VAR Hint Applies ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
Each table is normally partitioned into the same number of fragments as there are data nodes in the cluster. (This also means that DataMemory pages, once allocated to a given table, cannot be used by other tables.) Performing a data node recovery ...