PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction.
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html
Important A statement that is still permitted at this stage is not yet actually executed. The statement is not executed until all table-level options (if any) have also been checked, and the outcome of that process permits execution of the statement. When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
Most full-text variables described in this section must be set at server startup time. Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. The innodb_ft_num_word_optimize option ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a valid path expression or contains a * or ** wildcard. An error occurs if the json_doc argument is not a valid JSON document or any path argument is ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
For example, you might see an error like this: bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory If this happens, you must install the missing libraries manually or with your ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-timers-table.html
The setup_timers.TIMER_NAME value can be changed to select a different timer. The value can be any of the values in the performance_timers.TIMER_NAME column. Events already in progress may use the original timer for the begin time and the new timer ...For an explanation of how event timing occurs, see Section 25.4.1, “Performance Schema Event ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Introduced 5.7.21 Type String The destination keyring plugin for key migration. The format and interpretation of the option value is the same as described for the --keyring-migration-source ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-rwlock-instances-table.html
The rwlock_instances table lists all the rwlock (read write lock) instances seen by the Performance Schema while the server executes. An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access ...Shared-exclusive access is otherwise known as an sxlock and optimizes concurrency and improves scalability for read-write ...
https://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 10.14.4.2, “LDML Syntax ...