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/create-function-loadable.html
CREATE FUNCTION requires the INSERT privilege for the mysql system database because it adds a row to the mysql.func system table to register the function. For more information, see Section 5.6.1, “Installing and Uninstalling Loadable Functions”.
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system database because it removes the row from the mysql.func system table that registers the function. Because DROP FUNCTION removes the mysql.func row for the dropped function, the server does not ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-elements.html
Server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement INFORMATION_SCHEMA tables that provide views into the registered profiles. MySQL Enterprise Firewall is based on a plugin library that includes these elements: A ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-analysis.html
db The default database for the statement, or NULL if there is none. full_scan The total number of full table scans performed by occurrences of the statement. lock_latency The total time waiting for locks by timed occurrences of the statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
This includes any default value implied for this option by the setting of the InitialLogFileGroup data node configuration parameter. For example, you cannot have a tablespace and an undo log file with the same name, or an undo log file and a data ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
In the few cases that ANALYZE TABLE does not produce values good enough for your particular tables, you can use FORCE INDEX with your queries to force the use of a particular index, or set the max_seeks_for_key system variable to ensure that MySQL ...ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as well. In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
For example: CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10))); Prefixes can be up to 1000 bytes long (767 bytes for InnoDB tables, unless you have innodb_large_prefix set). Take this into account when specifying a prefix length for a nonbinary ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
When the innodb_stats_persistent setting is enabled, run the ANALYZE TABLE statement for an InnoDB table after creating an index on that table. Take this into account when specifying a prefix length for a nonbinary string column that uses a ...This ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...