Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
Here is a sample session that demonstrates use of mysqlimport: $> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test $> ed a 100 Max Sydow 101 Count Dracula . The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
There can be a maximum of four connection threads per thread group; these threads expire after a period of inactivity. MAX_THREAD_IDS_IN_GROUP The maximum thread ID of the threads in the group. This is the same as MAX(TP_THREAD_NUMBER) for the ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_init_pool_size Command-Line Format --authentication-ldap-sasl-init-pool-size=# System Variable authentication_ldap_sasl_init_pool_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10 Minimum ...
https://dev.mysql.com/doc/refman/8.4/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
You can use SET max_seeks_for_key=value as an alternative way to force MySQL to prefer key scans instead of table scans. When you use ORDER BY or GROUP BY to sort a column in a SELECT, the server sorts values using only the initial number of bytes ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
This is such a query: SELECT * FROM t1 WHERE t1.a IN (SELECT MAX(t1.b) FROM t2 WHERE ...); Here, MAX(t1.b) cannot aggregated in the outer query because it appears in the WHERE clause of that query. Strict mode produces an error for attempts to ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
Use the algorithm-specific system variables to adjust the default and maximum compression level for each permitted algorithm. mysqlx_connect_timeout Command-Line Format --mysqlx-connect-timeout=# System Variable mysqlx_connect_timeout Scope Global ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
Integer wait_for_my_writes_timeout Maximum time in seconds to wait for a read_only destination to apply the written transaction, before falling back to a read_write destination. wait_for_my_writes Type Integer Default Value 1 Minimum Value 0 Maximum ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-options-tab.html
The Options subtab enables you to set several types of options. Figure 8.19 The Options Tab Table options are grouped into the following sections: General Options Row Options Storage Options Merge Table Options The following sections describe these ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-partitioning-tab.html
The entries in this table are: Partition Values Data Directory Index Directory Min Rows Max Rows Comment Subpartitioning is also available. To enable partitioning for your table, check the Enable Partitioning check box. This enables the ...