Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. It is ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table-optimization.html
You may be able to its improve performance by setting these variables, as described in Section 6.6.4.6, “myisamchk Memory Usage”. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
However, it is not strictly necessary to include every column in both images, and we can often save disk, memory, and network usage by logging only those columns which are actually required. Startup Options Used with Binary Logging System Variables ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
Note This statement takes the place of the old RESET MASTER statement, which is no longer supported. RESET BINARY LOGS AND GTIDS [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'rewriter_enabled'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | rewriter_enabled | ON | ... Note If ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has ...
https://dev.mysql.com/doc/refman/8.4/en/show-profiles.html
SHOW PROFILES The SHOW PROFILES statement, together with SHOW PROFILE, displays profiling information that indicates resource usage for statements executed during the course of the current session. Note The SHOW PROFILE and SHOW PROFILES statements ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program.
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
over_clause is described in Section 14.20.2, “Window Function Concepts and Syntax”, which also includes other information about window function usage. MySQL supports aggregate functions that perform a calculation on a set of values. For general ...
https://dev.mysql.com/doc/refman/8.4/en/tuning-trace-purging.html
Using optimizer_trace_offset and optimizer_trace_limit, which are restrictions at the trace producer level, provide better (greater) speed and (less) memory usage than setting offsets or limits at the trace consumer (SQL) level with SELECT * FROM ...