MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 361 to 370 of 378 total results

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-regressor.html

Regressor Constructor Regressor.train() Regressor.fit() Regressor.predict() Regressor.score() Regressor.explain() Regressor.getExplainer() Regressor.unload() This class is similar to Classifier and Forecaster in that it represents an AutoML ...

27.3.6.8 Warning Object

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-warning.html

Warning represents a warning raised by statement execution, and has the following properties: code: MySQL error code (integer). Can be any one of 1 (NOTE), 2 (WARNING), or 3 (ERROR). You can also employ the JavaScript Error object, such as obtained ...

15.4.2.4 START REPLICA Statement

https://dev.mysql.com/doc/refman/9.7/en/start-replica.html

START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | ...

13.3 String Data Types

https://dev.mysql.com/doc/refman/9.7/en/string-types.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...

10.2.2.2 Optimizing Subqueries with Materialization

https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html

The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...

30.4.5.14 The ps_thread_account() Function

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-thread-account.html

Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. The value should match the THREAD_ID column from some ...

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/9.7/en/table-size-limit.html

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation ...

35.3.1 Configuring Trace Telemetry

https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace-configuration.html

Server Configuration Client Configuration Client Configuration Example Server Configuration The following are the server trace telemetry configuration variables: telemetry.trace_enabled System Variable telemetry.trace_enabled Scope Global Dynamic ...

35.3 OpenTelemetry Trace

https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace.html

Tracing telemetry enables you to visualize the flow of any processing action as it is processed through your server. The data for each action, a span, includes possible error information and timing data. Traces are generated for COM_QUERY commands ...

27.4.1 Trigger Syntax and Examples

https://dev.mysql.com/doc/refman/9.7/en/trigger-syntax.html

To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.27, “CREATE TRIGGER Statement”, and Section 15.1.41, “DROP TRIGGER Statement”. Here is a simple example that associates a ...

Displaying 361 to 370 of 378 total results