Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements-callable.html
For more information on MySQL stored procedures, please refer to Using Stored Routines. Notice that you have to use JDBC escape syntax, and that the parentheses surrounding the parameter placeholders are not optional: Example 7.4 Connector/J: Using ...
https://dev.mysql.com/doc/refman/8.4/en/account-locking.html
The server increments the Locked_connects status variable that indicates the number of attempts to connect to a locked account, returns an ER_ACCOUNT_HAS_BEEN_LOCKED error, and writes a message to the error log: Access denied for user ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
File renaming (whether during plugin initialization or termination) occurs according to the usual rules for automatic size-based log file rotation; see Manual Audit Log File Rotation. Enabling the Audit Log Flush Task MySQL Enterprise Audit provides ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
This chapter discusses several backup and recovery topics with which you should be familiar: Types of backups: Logical versus physical, full versus incremental, and so forth. If the primary fails, a secondary is automatically promoted to the role of ... It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by ...
https://dev.mysql.com/doc/refman/8.4/en/backup-strategy-summary.html
Make periodic incremental backups by flushing the logs with FLUSH LOGS or mysqladmin flush-logs. In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make sure that you can sleep well, ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
By default, the server autosizes the value at startup, but it can be set explicitly to override this default. If the server refuses a connection because the max_connections limit is reached, it increments the Connection_errors_max_connections status ... This section describes aspects of how the MySQL server manages client ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
This event executes once—one hour following its creation—by running an SQL statement that increments the value of the myschema.mytable table's mycol column by 1. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
How the Diagnostics Area is Cleared and Populated Nondiagnostic SQL statements populate the diagnostics area automatically, and its contents can be set explicitly with the SIGNAL and RESIGNAL statements. If the sql_notes system variable is set to 0, ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
When forcing InnoDB recovery, you should always start with innodb_force_recovery=1 and only increase the value incrementally, as necessary. To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
Join buffers for hash joins are allocated incrementally; thus, you can set join_buffer_size higher without small queries allocating very large amounts of RAM, but outer joins allocate the entire buffer. It is possible to control whether hash joins ...