Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-timing.html
If an enabled instrument is not timed, events produced by the instrument have NULL for the TIMER_START, TIMER_END, and TIMER_WAIT timer values. Events that have not yet completed have an END_EVENT_ID value of NULL. Events are collected by means of ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON GEOMETRY can store geometry values of any type. The other single-value types (POINT, LINESTRING, and POLYGON) restrict their values to a particular geometry type.
https://dev.mysql.com/doc/refman/8.4/en/static-format.html
NULL columns require additional space in the row to record whether their values are NULL. Each NULL column takes one bit extra, rounded up to the nearest byte. The expected row length in bytes for static-sized rows is calculated using the following ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
Use NULL to collect data for the default of 60 seconds. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
row *************************** Name: t1 Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2021-02-18 12:18:28 Update_time: ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-library-init.html
#include <mysql.h> #include <stdlib.h> int main(void) { if (mysql_library_init(0, NULL, NULL)) { fprintf(stderr, "could not initialize MySQL client library\n"); exit(1); } /* Use any MySQL API functions here */ mysql_library_end(); return ... int ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-anomaly-detection-logs.html
This column labels identified anomalous logs with a value of 1, non-anomalous logs with 0, and unlabeled logs with NULL. You can set either embedding_model or keyword_model to NULL, but you cannot set both to NULL. Anomaly detection for logs allows ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-data-drift-detection.html
mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); Run ML_PREDICT_TABLE to generate a table of predictions. mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); Run ML_PREDICT_ROW to generate predictions for a defined number of rows. MySQL AI ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-load-model.html
The following example loads an AutoML model from the model catalog by using the session variable mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); Where: @census_model is the session variable that contains the model handle. NULL is specified in ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-export.html
ML_MODEL_EXPORT Overview After you run ML_MODEL_EXPORT, the output table has these columns and formats: chunk_id: INT AUTO_INCREMENT PRIMARY KEY model_object: LONGTEXT DEFAULT NULL model_metadata: JSON See Model Metadata. ML_MODEL_EXPORT should work ... Use the ML_MODEL_EXPORT routine to export a model from the model catalog to a user defined ...