PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Any columns used as the partitioning key must comprise part or all of the table's primary key, if the table has one. If you define an explicit partitioning scheme for an NDB table, the table must have an explicit primary key, and any columns used in ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
When database db2 is copied to server1, the GTIDs of the transactions committed on server2, which are not in the binary log files on server1, must be added to gtid_purged for server1 to make the set complete. Example 19.2 Backup and restore scenario ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
Components must be loaded into the server before they can be used. For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles component loading and ...The ...MySQL supports manual component loading at runtime and automatic loading during server ...
https://dev.mysql.com/doc/refman/8.0/en/installing-development-tree.html
Prerequisites for Installing from Development Source Setting Up a MySQL Git Repository Prerequisites for Installing from Development Source To install MySQL from a development source tree, your system must satisfy the tool requirements listed at ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-admin.html
Database administrators should use the following guidelines to keep passwords secure. Account passwords can be expired so that users must reset them. A user who has access to modify the plugin directory (the value of the plugin_dir system variable) ...MySQL stores passwords for user accounts in the mysql.user system ...Access ...
https://dev.mysql.com/doc/refman/8.0/en/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. mysqldump adds a SET @@SESSION.sql_log_bin=0 statement to a dump file from a server where GTIDs are in use, which disables binary logging while the dump file is ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. This means that anyone can attempt to connect to the server using any user name, so you cannot make a database secure in any way unless all MySQL accounts have passwords. Warning ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...Standard ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-installation.html
To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). To install the validate_password component, use this statement: INSTALL COMPONENT ... This ...For general information about installing and uninstalling components, see Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/windows-extract-archive.html
If you do not install MySQL at C:\mysql, you must specify the path to the install directory during startup or in an option file. Extract the install archive to the chosen installation location using your preferred file-compression tool. To install ...Make sure that you are logged in as a user with administrator ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...