Search Results
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
Large fields are stored away from the page that holds the rest of the row data, as in dynamic row format. Because long variable-length column values are stored outside of the page that holds the row data, it is very efficient for rows that include ...It saves work for the developer, not to have to produce new unique values when inserting new ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
Command line: $> mysqld --innodb-buffer-pool-chunk-size=134217728 Configuration file: [mysqld] innodb_buffer_pool_chunk_size=134217728 The following conditions apply when altering innodb_buffer_pool_chunk_size: If the new ... You can configure ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace-autoextend-size.html
Configuring a larger extension size can help avoid fragmentation and facilitate ingestion of large amounts of data. By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally ...
https://dev.mysql.com/doc/internals/en/row-based-binary-logging.html
Unfortunately, by now the RBR/SBR terminology is probably too well entrenched for there to be much hope of a return to the proper RBL/SBL terms, so I must content myself with including this nomenclatural screed here. Logging in this format can be ...
https://dev.mysql.com/doc/internals/en/transformations-row-in.html
To rewrite a row IN subquery, the method used is Item_in_subselect::row_value_transformer. It works in almost the same way as the scalar analog, but works with Item_cache_row for caching left expression and uses references for elements of ...iN ...
https://dev.mysql.com/doc/refman/8.4/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Remove ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
But typically you don't want to see the entire table, particularly when it becomes large. As shown in the preceding section, it is easy to retrieve an entire table. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
However, the row constructor itself does not cover an index prefix, with the result that the optimizer uses only c1 (key_len=4, the size of c1): mysql> EXPLAIN SELECT * FROM t1 WHERE c1=1 AND (c2,c3) > (1,1)\G *************************** 1. The ...
https://dev.mysql.com/doc/refman/8.4/en/row-subqueries.html
A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-row.html
ML_PREDICT_ROW generates predictions for one or more rows of data specified in JSON format. After training and loading the model, you can generate predictions on one or more rows of data. Input Data to Generate a Row Prediction One way to generate ...The following example trains a dataset with the classification machine learning ...