Search Results
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
However, it is sent in plain text over the connection to the replica server instance. START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
For extended EXPLAIN output, the text displayed by a following SHOW WARNINGS includes materialize and materialized-subquery. The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
For example, if a full-text parser plugin is associated with a FULLTEXT index on the table, uninstalling the plugin makes the table unusable. UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. It requires the DELETE ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
If you find the text mysqld restarted in the error log (normally a file named host_name.err) you probably have found a query that causes mysqld to fail. Note that before starting mysqld with the general query log enabled, you should check all your ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
The server writes one file as tab-delimited text, one line per table row. Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud ...