PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-system-definition.html
The [system] section is used for parameters applying to the cluster as a whole. The Name system parameter is used with MySQL Enterprise Monitor; ConfigGenerationNumber and PrimaryMGMNode are not used in production environments. Except when using ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT Statements”. When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert.
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-functions.html
MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema and require no ...
https://dev.mysql.com/doc/refman/9.7/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
https://dev.mysql.com/doc/refman/9.7/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-thread-id.html
Note ps_thread_id() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in PS_THREAD_ID() and PS_CURRENT_THREAD_ID() functions instead. See Section 14.22, “Performance ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/9.7/en/kerberos-pluggable-authentication.html
Note Kerberos pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using Kerberos, ...