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-features-functions.html
(See Section 19.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. In such cases, a warning is still issued by this ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
SELECT (for table referenced in REPLACE clause LOAD DATA LOAD XML update event: UPDATE UPDATE ... WHERE (for tables referenced in UPDATE clause) Blocking Execution of Specific Events event items can include an abort item that indicates whether to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
For this reason, replication of such a statement may not be safe when STATEMENT mode is in use. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes ...In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-mode.html
Permissive mode allows operations that are not permitted in enforcing mode and logs those operations to the SELinux audit log. In disabled mode, polices are not enforced, and contexts are not applied to system objects, which makes it difficult to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-catalog-dashboard.html
The warning serves to remind you that running MySQL Installer in offline mode prevents you from downloading the latest MySQL products and product catalog updates. Proxy: MySQL Installer provides multiple proxy modes that enable you to download MySQL ...By default, and when an Internet connection is present, MySQL Installer attempts to update the catalog at startup every seven ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
When updates or deletes affect many rows, this results in much less storage space required for log files. Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based ...For ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
This type of repair is like that done by myisamchk --safe-recover. Caution Use the USE_FRM option only if you cannot use regular REPAIR modes. For a MyISAM table, if you do not get OK, you should try repairing it with myisamchk --safe-recover. With ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
This means that you should not chain two servers together in a two-way replication relationship unless you are sure that your updates can safely happen in any order, or unless you take care of mis-ordered updates somehow in the client code. For ...