Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
The size and sign of fixed precision types such as INTEGER and DECIMAL must be the same. Referential Actions When an UPDATE or DELETE operation affects a key value in the parent table that has matching rows in the child table, the result depends on ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table size. Of the tables that contain statement event rows, ...For more ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, limit operations to batches of rows by splitting large tables into smaller tables by using the batch_size option. For MySQL 9.4.1 and later, if ML_PREDICT_TABLE takes a ... ML_PREDICT_TABLE generates predictions for an entire table of trained ...
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
Performance Considerations By default, the entire table is read row by row and the checksum is calculated. For large tables, this could take a long time, thus you would only perform this operation occasionally. This row-by-row calculation is what ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); When you insert any other value into an AUTO_INCREMENT column, the column is set to that value and the sequence is reset so that the next automatically generated value follows ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
How do I tell whether a replication source server is using statement-based or row-based binary logging format? A.14.11. How do I tell a replica to use row-based replication? A.14.12. Note that if your replica has been disconnected from the source ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
If you have deleted a large number of rows from a partition or if you have made many changes to a partitioned table with variable-length rows (that is, having VARCHAR, BLOB, or TEXT columns), you can use ALTER TABLE ... You can use ALTER IGNORE ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-dump-instance-schema.html
The upload method used to transfer files to an Oracle Cloud Infrastructure Object Storage bucket has a file size limit of 1.2 TiB. The size of these columns therefore must not exceed approximately 0.74 times the value of the max_allowed_packet ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-restrictions.html
You should also be aware that queries using very large numbers of windows may require increasing the default thread stack size (thread_stack system variable). The SQL standard imposes a constraint on window functions that they cannot be used in ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-table-export.html
The data can then be uploaded into a table on a target MySQL server using MySQL Shell's parallel table import utility util.importTable() (see Section 12.4, “Parallel Table Import Utility”), which uses parallel connections to provide rapid data ... 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 ...