Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/verifying-md5-checksum.html
On Linux, it is part of the GNU Text Utilities package, which is available for a wide range of platforms. After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages.
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the statement. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
If a column is created from an expression, the default alias is the expression text, which can be quite long. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not ...