Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
The value is NULL if the row has not been changed since the sys schema was installed. (For example, the variable corresponding to the diagnostics.include_raw option is @sys.diagnostics.include_raw.) If the user-defined variable exists in the current ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-row-nonblocking.html
The two functions differ as follows: mysql_fetch_row() returns a MYSQL_ROW value containing the next row, or NULL. The meaning of a NULL return depends on which function was called preceding mysql_fetch_row(): When used after mysql_store_result() or ... enum net_async_status mysql_fetch_row_nonblocking(MYSQL_RES *result, MYSQL_ROW *row) Description Note mysql_fetch_row_nonblocking() is an asynchronous ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-active.html
If user is set to current or NULL, the following information displays. Use the ML_MODEL_ACTIVE routine to check which models are loaded and active for which users. All active users and models share the amount of memory defined by the shape, and it ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
It can be any string of characters, with the exception of colons (:), which are not permitted. The default value is NULL, which does not permit activating redo log archiving. subdir can be empty, null, or it can be left out. Attempting to restart ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-metrics-table.html
row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 3 MAX_COUNT: 3 MIN_COUNT: NULL AVG_COUNT: 0.046153846153846156 COUNT_RESET: 3 MAX_COUNT_RESET: 3 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
If you want to create your own FTS_DOC_ID column, the column must be defined as BIGINT UNSIGNED NOT NULL and named FTS_DOC_ID (all uppercase), as in the following example: Note The FTS_DOC_ID column does not need to be defined as an AUTO_INCREMENT ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
Unlike the case with other partitioning types, columns used for partitioning by KEY are not restricted to integer or NULL values. Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
If all arguments are NULL or the aggregate result is empty, the return value is NULL. The result is the narrowest MultiXxx or GeometryCollection value possible, with the result type determined from the non-NULL geometry arguments as follows: If all ... MySQL supports aggregate functions that perform a calculation on a set of ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-lengths.html
In addition, if the result set contains binary data, you must use this function to determine the size of the data, because strlen() returns incorrect results for any field containing null characters. The length for empty columns and for columns ...