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/crashing.html
MySQL updates the files on disk with the write() system call after every SQL statement and before the client is notified about the result. (This is not true if you are running with the delay_key_write system variable enabled, in which case data ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
If the application is dominated by reads, rather than updates, fewer pages need to be reorganized and recompressed after the index page runs out of room for the per-page “modification log” that MySQL maintains for compressed data. If the updates ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching values”. By limiting the search, it is possible to expend much less time and ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
If a thread is updating a nontransactional table, an operation such as a multiple-row UPDATE or INSERT may leave the table partially updated because the operation can terminate before completion. Since nontransactional statements cannot be rolled ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions.html
MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position 8.0.26 SOURCE_POS_WAIT() Block until the replica has read and applied all updates up to the specified position 8.0.26 ... The functions described ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-troubleshooting.html
Troubleshooting SELinux typically involves placing SELinux into permissive mode, rerunning problematic operations, checking for access denial messages in the SELinux audit log, and placing SELinux back into enforcing mode after problems are ...grep ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
STORED: Column values are evaluated and stored when rows are inserted or updated. Note Expression evaluation uses the SQL mode in effect at evaluation time. If any component of the expression depends on the SQL mode, different results may occur for ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
As a safety measure, InnoDB prevents INSERT, UPDATE, or DELETE operations when innodb_force_recovery is greater than 0. If you are able to dump your tables with an innodb_force_recovery value of 3 or less, then you are relatively safe that only some ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations. In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked ...For example, if you define a ...