PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer.html
Navigate to Program Files (x86) > MySQL > MySQL Installer for Windows to open the program folder. Select one of the following files: MySQLInstaller.exe to open the graphical application. An internet connection is required to download a manifest ...
https://dev.mysql.com/doc/refman/8.0/en/windows-installation-layout.html
Table 2.4 Default MySQL Installation Layout for Microsoft Windows Directory Contents of Directory Notes bin mysqld server, client and utility programs %PROGRAMDATA%\MySQL\MySQL Server 8.0\ Log files, databases The Windows system variable ... For ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-plugin-specific.html
keyring_aws_rotate_keys() Associated keyring plugin: keyring_aws keyring_aws_rotate_keys() rotates keys stored in the keyring_aws storage file named by the keyring_aws_data_file system variable. Rotation changes only the key that AWS KMS uses for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
SELECT * FROM INFORMATION_SCHEMA.ENGINES [WHERE ENGINE LIKE 'NDB%'] This is the equivalent of SHOW ENGINES, but uses the ENGINES table of the INFORMATION_SCHEMA database. You can also query the tables in the ndbinfo information database for ... This ...See Section 15.7.7.15, “SHOW ENGINE Statement”, for a usage example and more detailed ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If those arguments are not in the same SRS, an ER_GIS_DIFFERENT_SRIDS_AGGREGATION error occurs. For general information about these functions, ... MySQL supports aggregate functions that perform a calculation on a set of ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For nonfloating-point data types, inverse aggregation is always safe and is used regardless of the windowing_use_high_precision value. Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled ...Semijoins are not applicable to window function optimization because semijoins apply to subqueries in WHERE and JOIN ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
The minimum requirements for a valid CREATE EVENT statement are as follows: The keywords CREATE EVENT plus an event name, which uniquely identifies the event in a database schema. The event_name must be a valid MySQL identifier with a maximum length ...The event does not run unless the Event Scheduler is ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-backup.html
For these reasons, hot backups are desirable when your database “grows up” -- when the data is large enough that the backup takes significant time, and when your data is important enough to your business that you must capture every last change, ...The product is architected for efficient and reliable backups of tables created by the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
ORDER BY RAND() LIMIT 15; Influencing ORDER BY Optimization For slow ORDER BY queries for which filesort is not used, try lowering the max_length_for_sort_data system variable to a value that is appropriate to trigger a filesort. This section ...An ...
https://dev.mysql.com/doc/refman/8.0/en/alter-function.html
ALTER FUNCTION func_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...More ...