Search Results
https://dev.mysql.com/doc/refman/8.4/en/views.html
Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/8.4/en/which-version.html
When preparing to install MySQL, decide which version and distribution format (binary or source) to use. First, decide whether to install from an LTS series like MySQL 8.4, or install from an Innovation series like MySQL 9.4. Both tracks include ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions.html
MySQL supports window functions that, for each row from a query, perform a calculation using rows related to that row. The following sections discuss how to use window functions, including descriptions of the OVER and WINDOW clauses. For ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-command-line.html
The MySQL server can be started manually from the command line. To start the mysqld server from the command line, you should start a console window (or “DOS window”) and enter this command: C:\> "C:\Program Files\MySQL\MySQL Server ...
https://dev.mysql.com/doc/refman/8.4/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
You can restore your database server to its state at an arbitrary time using the binary log files included in the backups. The process assumes that following conditions are met: The backed-up MySQL Server has had its binary logging enabled (which ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.source.html
To fix a corruption problem in a replication source database, you can restore the backup, taking care not to propagate unnecessary SQL operations to the replica servers: Shut down the source database and then use, for example, the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-compression-options.html
For an overview on backup compression, see Section 4.3.4, “Making a Compressed Backup”. For a regular backup, among all the storage engines supported by MySQL, only data files of the InnoDB format are compressed, and they bear the .ibz ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-encrypted-innodb-options.html
MySQL Enterprise Backup supports encrypted InnoDB tablespaces and encrypted binary/relay logs. For details on how MySQL Server encrypts and decrypts these items, see InnoDB Data-at-Rest Encryption and Encrypting Binary Log Files and Relay Log Files ...