Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
To tell MySQL to accept the query, you can use the ANY_VALUE() function: SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name; Alternatively, disable ONLY_FULL_GROUP_BY. Here, too, ANY_VALUE() can be used, if it is immaterial which name ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
For example: [mysqld] innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend The autoextend and max attributes can be used only for the data file that is specified last. To specify a maximum size for an auto-extending data file, use the max ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
(This technique is inapplicable if NULL must be permitted as a valid name value.) Use ANY_VALUE() to refer to address: SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name; In this case, MySQL ignores the nondeterminism of address values ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
--max-allowed-packet=value Command-Line Format --max-allowed-packet=value Type Numeric Default Value 16777216 The maximum size of the buffer for client/server communication. --max-join-size=value Command-Line Format --max-join-size=value Type ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-optimizer-category.html
Histogram Generation Max Mem Size The maximum amount of memory available for generating histogram statistics. Max Length For Sort Data The maximum size of parameter values that can be sent with the mysql_stmt_send_long_data() C API function. Max ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
In case the max parameter is not set, you cannot overlap across documents. Max: maximum number of characters or words to be included in each segment. If left unspecified, there is no maximum size enforcement on the chunks of text. Overlap: maximum ... This section describes how to generate vector embeddings for files or folders stored in Object Storage, and load the embeddings into a vector store ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
This is equivalent to the expression (min <= expr AND expr <= max) if all the arguments are of the same type. expr NOT BETWEEN min AND max This is the same as NOT (expr BETWEEN min AND max). The number of values in the IN() list is only limited by ... Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
The only aggregate functions used in the select list (if any) are MIN() and MAX(), and all of them refer to the same column. Any other parts of the index than those from the GROUP BY referenced in the query must be constants (that is, they must be ... The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
DBMS connection read timeout interval (in seconds):[30] The maximum amount of time the query can take to return data from the DBMS. DBMS connection timeout interval (in seconds): [60] Maximum time to wait before a connection attempt is aborted. Max ... This section provides configuration options that affect the SQL editor functionality in MySQL ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-constants.html
Ndb constructor 4.3.1.14.36 PROPERTY_CLUSTER_MAX_CACHED_SESSIONS public static final String PROPERTY_CLUSTER_MAX_CACHED_SESSIONS = "com.mysql.clusterj.max.cached.sessions"; Since 9.4.0 Each Cluster/J session uses an Ndb object that holds a ...The ...