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/replication-solutions-backups-rawdata.html
To shut down the server and back up the files: Shut down the replica MySQL server: $> mysqladmin shutdown Copy the data files. If you want to be able to restore the data and operate as a replica (for example, in the event of failure of the replica), ... To guarantee the integrity of the files that are copied, backing up the raw data files on your MySQL replica should take place while your replica server is shut ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions.html
This section provides general notes and advice on using replication for specific solution types. For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 19.4.1, ... Replication can be used in many different environments for a range of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads.html
When a START REPLICA statement is issued on a replica server, the replica creates an I/O (receiver) thread, which connects to the source and asks it to send the updates recorded in its binary logs. The replication receiver thread reads the updates ...When replica_parallel_workers (in MySQL 8.0.26 and earlier, use slave_parallel_workers) is equal to 0, the replica creates an SQL (applier) thread to read the relay log that is written by the replication receiver thread and execute the transactions contained in ...
https://dev.mysql.com/doc/refman/8.0/en/row-constructor-optimization.html
For example, these two statements are semantically equivalent: SELECT * FROM t1 WHERE (column1,column2) = (1,1); SELECT * FROM t1 WHERE column1 = 1 AND column2 = 1; In addition, the optimizer handles both expressions the same way. However, the row ...The optimizer is less likely to use available indexes if the row constructor columns do not cover the prefix of an ...
https://dev.mysql.com/doc/refman/8.0/en/selinux.html
Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that implements access rights by applying a security label referred to as an SELinux context to each system object. SELinux policy modules use SELinux contexts to define ...Interaction between system objects is only permitted if a policy rule allows ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
Note MySQL 5.7 has a dependency on the Oracle Developer Studio Runtime Libraries; but this does not apply to MySQL 8.0. For example: $> gunzip mysql-8.0.44-solaris11-x86_64.pkg.gz To install a new package, use pkgadd and follow the onscreen prompts.
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html
Note MySQL 8.0 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. To use a standard tar binary installation, use the notes provided in Section 2.2, “Installing MySQL on Unix/Linux Using Generic ...For ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
over_clause is described in Section 14.20.2, “Window Function Concepts and Syntax”, which also includes other information about window function usage. ST_Collect([DISTINCT] g) [over_clause] Aggregates geometry values and returns a single ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
The coordinate system on that plane is Cartesian using a length unit (meters, feet, and so forth), rather than degrees of longitude and latitude. Unlike projected SRSs, it is not georeferenced and it does not necessarily represent Earth. MySQL ... A ...
https://dev.mysql.com/doc/refman/8.0/en/view-check-option.html
It also prevents updates to rows for which the WHERE clause is true but the update would cause it to be not true (in other words, it prevents visible rows from being updated to nonvisible rows). In a WITH CHECK OPTION clause for an updatable view, ... The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not ...