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/innodb-read-only-instance.html
To enable read-only mode for an entire MySQL instance, specify the following configuration options at server startup: --innodb-read-only=1 If the instance is on read-only media such as a DVD or CD, or the /var directory is not writeable by all: ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
An exclusive (X) lock permits the transaction that holds the lock to update or delete a row. Transaction data for an intention lock appears similar to the following in SHOW ENGINE INNODB STATUS and InnoDB monitor output: TABLE LOCK table `test`.`t` ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html
JSON_ARRAY_INSERT(json_doc, path, val[, path, val] ...) Updates a JSON document, inserting into an array within the document and returning the modified document. In MySQL 8.0.4, the optimizer can perform a partial, in-place update of a JSON column ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
To make sure that you can take advantage of any new capabilities, update your grant tables to the current structure whenever you upgrade MySQL. MySQL account information is stored in the tables of the mysql system schema. This database and the ...
https://dev.mysql.com/doc/refman/8.0/en/non-typed-operators.html
/ Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) = Equal operator ^ Bitwise XOR AND, && Logical AND BETWEEN ... ->> Return value from JSON column after ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...(Bug #11754117, Bug #45670) This issue does not affect tables using the InnoDB storage engine, since an InnoDB table with an AUTO_INCREMENT column requires at least one key where the auto-increment column is the only or leftmost ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
The account can also be safely used by an administrator to apply or reapply transactions from mysqlbinlog output, for example to recover from a replication error on the channel. After setting up the user account, use the GRANT statement to grant ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
This applies to mixed-format replication as well, since this enables some updates to be replicated using the statement-based format. However, it should be safe to use --replicate-do-db for this purpose if you are using row-based replication only, ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
(This is a condition likely to exist on a replica if you have issued a STOP REPLICA statement or if the replica is highly loaded.) For a server where GTIDs are in use (gtid_mode is ON), issuing RESET REPLICA has no effect on the GTID execution ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
For example, to ensure safe startup and shutdown of MySQL you could use the following commands to add the right links: $> ln /etc/init.d/mysql /etc/rc3.d/S91mysql $> ln /etc/init.d/mysql /etc/rc0.d/K02mysql To remove MySQL, the installed package ...