Search Results
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
For a server where binary logging is enabled (log_bin is ON), RESET BINARY LOGS AND GTIDS deletes all existing binary log files and resets the binary log index file, resetting the server to its state before binary logging was started. When ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
If the column exists when the rules table is loaded into memory, the plugin updates it with the pattern digest. If the column exists when the rules table is loaded into memory, the plugin updates it with the normalized form of the pattern. Users ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
If given: RETAIN CURRENT PASSWORD retains an account current password as its secondary password, replacing any existing secondary password. SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { ...
https://dev.mysql.com/doc/refman/8.4/en/set-role.html
If a user executes SET ROLE DEFAULT during a session, an error occurs if any default role cannot be activated (for example, if it does not exist or is not granted to the user). The named roles need not exist or be granted to the account. SET ROLE { ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause. row ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session.
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
If no clause is named and no extra channels exist, the statement applies to the default channel. When a replication channel has gaps, the replica’s database is in a state that might never have existed on the source. START REPLICA [thread_types] ...