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/mysql-cluster-upgrade-downgrade-7-6.html
If you are downgrading from NDB 7.6 to NDB 7.5 (or earlier), you must set an explicit value for IndexMemory in the cluster configuration file if none is already present. This section provides information about compatibility between different NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-setup.html
Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files When you download MySQL Installer for the first time, a setup wizard guides you through the initial installation of MySQL products. Choosing one of the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
Note Attempting to replicate invoked features using statement-based replication produces the warning Statement is not safe to log in statement format. For example, trying to replicate a loadable function with statement-based replication generates ...
https://dev.mysql.com/doc/refman/5.7/en/show-variables.html
For example: SELECT @@GLOBAL.innodb_data_file_path; Most system variables can be set at server startup (read-only variables such as version_comment are exceptions). See Section 5.1.8, “Using System Variables”, and Section 13.7.4.1, “SET Syntax ... SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geojson-functions.html
This example shows the parsing result for a simple GeoJSON object: mysql> SET @json = '{ "type": "Point", "coordinates": [102.0, 0.0]}'; mysql> SELECT ST_AsText(ST_GeomFromGeoJSON(@json)); +--------------------------------------+ | ... This section ...Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-object-shapes.html
The return values 1 and 0 indicate true and false, respectively, except for ST_Distance() and Distance(), which return distance values. For example, it returns 0 if the first argument is a Polygon or MultiPolygon and/or the second argument is a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema.html
You can view a list of InnoDB INFORMATION_SCHEMA tables by issuing a SHOW TABLES statement on the INFORMATION_SCHEMA database: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB%'; For table definitions, see Section 24.4, “INFORMATION_SCHEMA ... This section provides information and usage examples for InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily defined and then altered in Section 13.7.5.18, “SHOW EVENTS Statement”): mysql> SHOW CREATE EVENT myschema.e_daily\G ... SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html
You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disks. You can move databases or tables from the database directory to other ...To determine the location of your data directory, use this statement: SHOW VARIABLES LIKE ...