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/macos-installation.html
The user you use to perform the installation must have administrator privileges. For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/supportedplatforms/database.html. MySQL for macOS is available in a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html
file_name Sometimes you may want your script to display progress information to the user. For this you can insert statements like this: SELECT '<info_to_display>' AS ' '; The statement shown outputs <info_to_display>. You can also invoke mysql with ... The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
The purge operation can write disk blocks for a series of index values more efficiently than if each value were written to disk immediately. During this time, disk I/O is increased, which can cause a significant slowdown for disk-bound queries. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-usage.html
The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform their own processing on the data. For additional information about the differences between non-x$ and x$ views, see Section ...Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
If you have set a password for the root account, deleted the anonymous account, or created a new user account, then to connect to the MySQL server you must use the appropriate -u and -p options with the commands shown previously. For more ...(Be ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
Table 6.12 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-rules.html
This is a subset of the syntax described in the LDML specification available at http://www.unicode.org/reports/tr35/, which should be consulted for further information. Instead, it “resets” the ordering for subsequent shift rules to cause them ...MySQL recognizes a large enough subset of the syntax that, in many cases, it is possible to download a collation definition from the Unicode Common Locale Data Repository and paste the relevant part (that is, the part between the <rules> and </rules> tags) into the MySQL Index.xml ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
By doing so, it is possible to expend much less time and effort in finding matching rows than would be required to scan all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
Disable condition filtering for the session: SET optimizer_switch = 'condition_fanout_filter=off'; . To the extent that the optimizer can use information about conditions on rows selected from one table and passed to the next, the more accurately it ... In join processing, prefix rows are those rows passed from one table in a join to the ...