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/spatial-types.html
MySQL spatial extensions enable the generation, storage, and analysis of geographic features: Data types for representing spatial values Functions for manipulating spatial values Spatial indexing for improved access times to spatial columns The ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Storage engines are MySQL components that handle the SQL operations for ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/5.7/en/updating-yum-repo.html
Upgrading MySQL Upgrade MySQL and its components by the following command, for platforms that are not dnf-enabled: sudo yum update mysql-server For platforms that are dnf-enabled: sudo dnf upgrade mysql-server Alternatively, you can update MySQL by ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL system ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
It is sometimes possible for a multiple-table view to be updatable, assuming that it can be processed with the MERGE algorithm. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, ...
https://dev.mysql.com/doc/refman/5.7/en/reproducible-test-case.html
For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or Problems”. If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-connection-strings.html
(See the documentation for the respective executable.) It is also possible to set the connection string for all nodes in the cluster at once by placing it in a [mysql_cluster] section in the management server's my.cnf file. Write the connection ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
process_id This node's process ID angel_process_id Process ID of this node's angel process process_name Name of the executable service_URI Service URI of this node (see text) Notes node_id is the ID assigned to this node in the cluster. For an ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...