Search Results
https://dev.mysql.com/doc/refman/8.4/en/security-plugins.html
(MySQL Enterprise Edition only) MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against lists of accepted statement patterns. MySQL includes ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-mbr.html
MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and g2. The return values 1 and 0 indicate true and false, respectively. The MBR (also known as the bounding ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine instead. Stored routines can be particularly ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
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 ...