Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-sql-log-bin.html
It is not possible to set the session value of sql_log_bin within a transaction or subquery. mysqldump adds a SET @@SESSION.sql_log_bin=0 statement to a dump file from a server where GTIDs are in use, which disables binary logging while the dump ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
If you use the following log file options, their values must differ for each server: --general_log_file=file_name --log-bin[=file_name] --slow_query_log_file=file_name --log-error[=file_name] For further discussion of log file options, see Section ...Or you might want to give different users access to different mysqld servers that they manage ...Or you might ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
mysql sends each SQL statement that you issue to the server to be executed. For server side help, type 'help contents' If mysql is invoked with the --binary-mode option, all mysql commands are disabled except charset and delimiter in noninteractive ...There is also a set of commands that mysql itself ...ssl_session_data_print ...
https://dev.mysql.com/doc/refman/8.4/en/expired-password-handling.html
If the server disconnects the client, it returns an ER_MUST_CHANGE_PASSWORD_LOGIN error: $> mysql -u myuser -p Password: ****** ERROR 1862 (HY000): Your password has expired. After that has been done, the server restores normal access for the ...
https://dev.mysql.com/doc/refman/8.4/en/server-loadable-functions.html
A query rewriter examines statements received by MySQL Server and possibly rewrites them before the server executes them. MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during ...For ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-error-logging.html
Server Error Logging 3.1.2.3 Server Error Logging MySQL HeatWave on AWS logs MySQL Server diagnostic information such as errors, warnings, and status updates to the Performance Schema error_log table. You can use a command-line client such as MySQL ...For information about connecting to the DB System from a client, see Connecting from a ...
https://dev.mysql.com/doc/workbench/en/wb-admin-server-management.html
Manage your MySQL instances with a comprehensive view of your MySQL server connections. Each connection made to the MySQL server is represented by a separate connection tab. The visual tree-based navigation provides detailed information about ...On ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-server-states.html
If you see this status for other servers, it can also mean that the member where you query this table is part of a partition, where a subset of the group's servers can contact each other but cannot contact the other servers in the group. However, a ... The state of a Group Replication group member shows its current role in the ...
https://dev.mysql.com/doc/refman/8.4/en/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. See Section 15.7.8.3, “FLUSH Statement”, Section 6.5.2, “mysqladmin — A MySQL Server Administration Program”, and Section 6.5.4, “mysqldump — A ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
It contains tables that store information required by the MySQL server as it runs. Any components listed in this table are installed by a loader service during the server startup sequence. During the normal startup sequence, the server loads ...A ...