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
Displaying 761 to 769
of 769 total results
- « Previous
- 75
- 76
- 77
https://dev.mysql.com/doc/refman/8.0/en/update-optimization.html
An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the number of indexes that are updated. Another way to get fast updates is to delay ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
Usually, newer MySQL versions add features and improve performance but there are cases where an upgrade might run slower for specific queries. MySQL supports upgrading between minor versions (within an LTS series) and to the next major version ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password.html
The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This component exposes system variables that enable you to configure password policy, and status ...
https://dev.mysql.com/doc/refman/8.0/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view. Indexes can be used for views processed using the merge algorithm. However, a ...
https://dev.mysql.com/doc/refman/8.0/en/views.html
Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions.html
MySQL supports window functions that, for each row from a query, perform a calculation using rows related to that row. The following sections discuss how to use window functions, including descriptions of the OVER and WINDOW clauses. For ...
https://dev.mysql.com/doc/refman/8.0/en/working-with-null.html
The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-system-monitoring.html
For general X Plugin monitoring, use the status variables that it exposes. For information specifically about monitoring the effects of message compression, see Monitoring Connection Compression for X Plugin. Monitoring SQL Generated by X Plugin ...