Search Results
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
In this case, the host name must be specified in a user table row on the server host, even though you are running the client program on the same host as the server. Normally, you should have one row in the user table that exactly matches the host ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
INTO DUMPFILE writes a single row to a file without any formatting. If the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. If the query returns multiple rows, error 1172 occurs ...
https://dev.mysql.com/doc/refman/8.4/en/static-format.html
The expected row length in bytes for static-sized rows is calculated using the following expression: row length = 1 + (sum of column lengths) + (number of NULL columns + delete_flag + 7)/8 + (number of variable-length columns) delete_flag is 1 for ...It is also the fastest of the on-disk formats due to the ease with which rows in the data file can be found on disk: To look up a row based on a row number in the index, multiply the row number by the row length to calculate the row ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-an-anomaly-detection-model.html
row *************************** id: 4 parsed_log_segment: System shutdown initiated ml_results: {"summary": "\nThe system is shutting down.", "index_map": [10], "predictions": {"is_anomaly": 1}, "probabilities": {"normal": 0.0, "anomaly": 1.0}} The ...Both datasets have labeled and unlabeled rows, but only the dataset for semi-supervised learning uses this for ...To ...
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
You can run the following routines as needed with no changes: ML_TRAIN ML_MODEL_LOAD ML_EXPLAIN ML_PREDICT_TABLE ML_EXPLAIN_TABLE ML_SCORE If you run ML_PREDICT_ROW or ML_EXPLAIN_ROW on data loaded from Object Storage, you cannot use a FROM clause.
https://dev.mysql.com/doc/internals/en/heap-directory.html
All the MySQL table handlers (that is, the handlers that MySQL itself produces) have files with similar names and functions. Thus, this (heap) directory contains a lot of duplication of the myisam directory (for the MyISAM table handler). Such ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
When loading multiple compressed files, it is best to prepare files of similar size, and in the range of 80-120 MB each. HEADER: Adds a header row to the CSV file based on the selected option (ON or OFF). If HEADER and IGNORE are both specified, ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
With the mysql_info() C API function, you can find out how many rows were copied by ALTER TABLE. To change the InnoDB table to use compressed row-storage format: ALTER TABLE t1 ROW_FORMAT = COMPRESSED; The ENCRYPTION clause enables or disables ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: NULL normalized_pattern: NULL The rule specifies a pattern template indicating which SELECT ... To ...