Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). row *************************** LOGGED: 2020-08-06 09:25:00.338624 THREAD_ID: 0 PRIO: System ERROR_CODE: ...Typically, the server writes diagnostics to a file on the server host or to a system log ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-history.html
The Output is located at the bottom of MySQL Workbench. The Action Output panel displays a summary of the communication between the active MySQL connection in MySQL Workbench and the MySQL server, and can refer to errors or general information. Its ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-a-forecasting-model.html
mysql> CALL sys.ML_TRAIN('forecasting_data.electricity_demand_train', 'demand', JSON_OBJECT('task', 'forecasting', 'datetime_index', 'date', 'endogenous_variables', JSON_ARRAY('demand')), @model); Where: forecasting_data.electricity_demand_train is ...The following data types for this column are supported: DATETIME, TIMESTAMP, DATE, TIME, and YEAR, or an auto-incrementing ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a Transaction_payload_event). Compressed ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-requirements.html
(In MySQL 8.4, this is the default.) Group members need to log transactions that are received from their donors at joining time and applied through the replication applier, and to log all transactions that they receive and apply from the group.
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
The DEFINER Attribute The SQL SECURITY Characteristic Examples Orphan Stored Objects Risk-Minimization Guidelines The DEFINER Attribute A stored object definition can include a DEFINER attribute that names a MySQL account. Orphan Stored Objects An ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-forecasting-model.html
mysql> CALL sys.ML_TRAIN('forecasting_data.electricity_demand_train', 'demand', JSON_OBJECT('task', 'forecasting', 'datetime_index', 'date', 'endogenous_variables', JSON_ARRAY('demand')), @model); Where: forecasting_data.electricity_demand_train is ...The following data types for this column are supported: DATETIME, TIMESTAMP, DATE, TIME, and YEAR, or an auto-incrementing ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-performance-extensions.html
Default Value com.mysql.cj.PerConnectionLRUFactory Since Version 5.1.1 serverConfigCacheFactory Name of a class implementing 'com.mysql.cj.CacheAdapterFactory', which will be used to create caches for MySQL server configuration values. Default Value ... callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is set to ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
This means that they cannot be accessed by MySQL clients, and that they cannot be replicated. The Ndb object and its associated Dictionary support one schema transaction at a time. Tables created using this method cannot be seen by the MySQL Server, ...For these reasons, it is often preferable to avoid working with ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndb-api.html
This means that such applications are not bound by the MySQL privilege system; any NDB API application has read and write access to any NDB table stored in the same NDB Cluster at any time without restriction. It is also possible to perform ... The ...