Search Results
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... For statement-based or mixed-format replication, one implication of this indeterminism is that such a query can produce different results on the ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links.html
For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE statement instead of symbolic links, as explained in Section 17.6.1.2, “Creating Tables Externally”. To determine the location of your data directory, use this statement: SHOW ... You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new ...
https://dev.mysql.com/doc/refman/8.4/en/sys-diagnostics.html
statement_truncate_len, @sys.statement_truncate_len The maximum length of statements returned by the format_statement() function. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-instrument-default-enabled.html
Example mysql> SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf'); +-------------------------------------------------------------------+ | sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf') | ... Returns YES or ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-instrument-default-timed.html
Example mysql> SELECT sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf'); +-----------------------------------------------------------------+ | sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf') | ... Returns YES or NO to ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-consumer.html
Example Disable all statement consumers: mysql> CALL sys.ps_setup_disable_consumer('statement'); +----------------------+ | summary | +----------------------+ | Disabled 4 consumers | +----------------------+ . Disables Performance Schema consumers ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-enable-consumer.html
Example Enable all statement consumers: mysql> CALL sys.ps_setup_enable_consumer('statement'); +---------------------+ | summary | +---------------------+ | Enabled 4 consumers | +---------------------+ . Enables Performance Schema consumers with ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/8.4/en/thread-information.html
row *************************** Id: 20 User: me Host: localhost:52943 db: test Command: Query Time: 0 State: starting Info: SHOW PROCESSLIST Threads can be killed with the KILL statement. To ascertain what your MySQL server is doing, it can be ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-installation.html
To do this, put these lines in the server my.cnf file, adjusting the .so suffix for your platform as necessary: [mysqld] plugin-load-add=thread_pool.so To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW ...