Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-configuration.html
Configuration 19 Configuration The MySQL configuration comprises global system variables and session variables, which define its operation. Creating a MySQL Configuration Copying a MySQL Configuration MySQL Configuration Details System ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
To obtain memory for filesort operations, the optimizer allocates memory buffers incrementally as needed, up to the size indicated by the sort_buffer_size system variable. Take into account that the size of column values stored in the sort buffer is ...If this is not possible, try the following strategies: Increase the sort_buffer_size variable ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-firewall.html
$> cd /usr/local/mysql $> bin/mysql -u root -p mysql < /usr/local/mysql/share/linux_install_firewall.sql Enter password: (enter root password here) To enable the firewall, enable the mysql_firewall_mode system variable. By default, this variable is ... MySQL Enterprise Firewall is an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
Normally, character values in result sets are converted to the character set indicated by the character_set_results system variable. If you use mysql_use_result(), the value of this variable is zero. In this case, charsetnr corresponds to the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
Note To use this method, you need to enable the DB system to access the OCI Object Storage bucket. In earlier versions of MySQL, if you are loading a vector store table on a database system for the first time, create a new schema dedicated for task ... 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/connectors/en/connector-python-django-backend.html
When the Connector/Python back end does this, it arranges for the sql_mode system variable to be set to TRADITIONAL at startup. Django Configuration Django uses a configuration file named settings.py that contains a variable called DATABASES (see ...
https://dev.mysql.com/doc/connector-python/en/connector-python-django-backend.html
When the Connector/Python back end does this, it arranges for the sql_mode system variable to be set to TRADITIONAL at startup. Django Configuration Django uses a configuration file named settings.py that contains a variable called DATABASES (see ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Note In previous versions of MySQL, when evaluating an expression containing LEAST() or GREATEST(), the server attempted to guess the context in which the function was used, and to coerce the function's arguments to the data type of the expression ... 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-replication-compatibility-upgrade.html
The deprecated Group Replication system variable group_replication_allow_local_lower_version_join can be used in such situations to override the normal compatibility policies. During an online upgrade procedure, if the group is in single-primary ...
https://dev.mysql.com/doc/refman/8.4/en/insert-optimization.html
If you are adding data to a nonempty table, you can tune the bulk_insert_buffer_size variable to make data insertion even faster. To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single ...