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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-disconnecting.html
To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. Contact your administrator to find out what connection parameters you should use to connect (that is, what host, user name, ...If the server runs on a machine other than the one where you log in, you must also specify a host ...