Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the server writes diagnostics to a file on the server host or to a system log service. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The processlist table contains a row for each server process: mysql> SELECT * FROM performance_schema.processlist\G ...For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-key-rotation.html
When binary log encryption is enabled, you can rotate the binary log master key at any time while the server is running by issuing ALTER INSTANCE ROTATE BINLOG MASTER KEY. When you rotate the binary log master key manually, MySQL Server takes the ...You can rotate the binary log master key on a regular basis to comply with your organization's security policy, and also if you suspect that the current or any of the previous binary log master keys might have been ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
You can add another replica to an existing replication configuration without stopping the source server. To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ...If an event runs on the new replica that has already run on the source, the duplicated operation causes an ...
https://dev.mysql.com/doc/refman/8.4/en/restart.html
One use for RESTART is when it is not possible or convenient to gain command-line access to the MySQL server on the server host to restart it. For example, SET PERSIST_ONLY can be used at runtime to make configuration changes to system variables ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL statement. If there are large text or binary data values to be sent, you can send them in chunks to the server using ... To prepare and execute ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
The mandatory_roles and activate_all_roles_on_login system variables enable defining mandatory roles and automatic activation of granted roles when users log in to the server. (These role attributes can be changed later with the ALTER USER ...Like ...
https://dev.mysql.com/doc/refman/8.4/en/unix-signal-response.html
This section describes how the MySQL server and client programs respond to signals. Server Response to Signals Client Response to Signals Server Response to Signals mysqld responds to signals as follows: SIGTERM causes the server to shut down. This ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
Statement Monitoring Statement monitoring begins from the moment the server sees that activity is requested on a thread, to the moment when all activity has ceased. Typically, this means from the time the server gets the first packet from the client ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/8.4/en/user-names.html
An account is defined in terms of a user name and the client host or hosts from which the user can connect to the server. The default can be overridden easily, because client programs permit any user name to be specified with a -u or --user option.