Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
The information required for recovery is stored in the replica's applier metadata repository. Set relay_log_info_repository = TABLE, which stores the replication SQL thread position in the InnoDB table mysql.slave_relay_log_info, and updates it ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
Encryption helps to protect these files and the potentially sensitive data contained in them from being misused by outside attackers, and also from unauthorized viewing by users of the operating system where they are stored. Stored programs and ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
Instead, use SHA2() or some other one-way hashing function and store the hash value. That does not mean the combination needs to be a random string of characters that is difficult to remember and reproduce, although this is a good approach if you ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
Within stored programs, LIMIT parameters can be specified using integer-valued routine parameters or local variables. INTO form of SELECT enables the query result to be written to a file or stored in variables. For SQL_SMALL_RESULT, MySQL uses ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For information about options supported by CMake, run either of these commands in ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
MySQL maintains information about available spatial reference systems for spatial data in the data dictionary mysql.st_spatial_reference_systems table, which can store entries for projected and geographic SRSs. Parsed definitions are stored in the ... A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
The server stores resource limits for an account in the user table row corresponding to the account. The max_questions, max_updates, and max_connections columns store the per-hour limits, and the max_user_connections column stores the ... One means ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
As of this release, stored, generated columns are not re-evaluated when the underlying columns are unavailable. (Bug #114507, Bug #36455468) It was possible for a deterministic stored function to return an incorrect result when the function used ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-streaming.html
You can either store the single-file backup directly on the remote system, or invoke mysqlbackup with the copy-back-and-apply-log command on the other end to restore the backup to a remote MySQL server. Example 4.14 Single-file Backup to a Remote ...