PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. This optimzation is performed by default whenever the optimizer determines that using it would allow for faster execution of the query. Because the algorithm that makes this ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
This might result in quicker lock release than the MERGE algorithm so that other clients that use the view are not blocked as long. In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. The optional ALGORITHM clause for ...
https://dev.mysql.com/doc/refman/5.7/en/xa.html
This document is published by The Open Group and available at http://www.opengroup.org/public/pubs/catalog/c193.htm. In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
The numeric values specified for this option correspond to isolation levels such as REPEATABLE READ. This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
This issue can occur if MySQL is configured to read from or write to a non-default directory or file. In this case, a “denial” message is logged to /var/log/audit/audit.log: $> grep "denied" /var/log/audit/audit.log type=AVC ... Troubleshooting ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A consequence of this is that SET member values should not themselves contain commas. For more information on this limit, see Limits Imposed by .frm File Structure. For example, you can retrieve numeric values from a SET column like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. This includes any ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). As soon as this lock has been acquired, the binary log coordinates are read and the lock is released. While the server ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
In this Manual, we use dashes in option names, except where underscores are significant. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as --password. This ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-linux-quick.html
This is an example of the subrepository's default entry in the file (the baseurl entry in your file might look different, depending on your Linux distribution): [mysql-tools-preview] name=MySQL Tools Preview ...To do so, you need to remove your old ... Note Installation packages for MySQL Shell are available only for a limited number of Linux distributions, and only for 64-bit ...