PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/replication-features-reserved-words.html
Replication can fail in such cases with Error 1064 You have an error in your SQL syntax..., even if a database or table named using the reserved word or a table having a column named using the reserved word is excluded from replication. In any SQL ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html
row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: testuser@localhost Modified: 2018-08-08 13:54:11 Created: 2018-08-08 13:54:11 Security_type: DEFINER Comment: character_set_client: utf8 collation_connection: ...It returns ...A similar statement, SHOW FUNCTION STATUS, displays information about stored functions (see Section 13.7.5.20, “SHOW FUNCTION STATUS ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. Pages are ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. PAGES_FREE The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-and-plugins.html
The associated event information, including aggregate information, remains readable in performance_schema database tables. Removing a plugin with UNINSTALL PLUGIN does not affect information already collected for code in that plugin. For additional ...Time spent executing the code while the plugin was loaded was still spent even if the plugin is unloaded ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. The function library base name is openssl_udf and the suffix is platform dependent. For example, the file name on Linux or ... MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory (the directory named by the plugin_dir system ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
If you already created some InnoDB tables, also delete the corresponding .frm files for these tables, and any .ibd files if you are using multiple tablespaces, from the MySQL database directories. The troubleshooting steps for InnoDB I/O problems ...Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all ib_logfile ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-use-cases.html
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Depending on the number of servers which fail the group might have degraded performance or scalability, but it is ...