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/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For statements that can be determined at function definition time to return a ...By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine ...
https://dev.mysql.com/doc/refman/5.7/en/channels-startup-options.html
--slave_net-timeout=N This value is set per channel, so that each channel waits for N seconds to check for a broken connection. --max-relay-log-size=size Maximum size of the individual relay log file for each channel; after reaching this limit, the ... This section describes startup options which are impacted by the addition of replication ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
To execute RENAME TABLE, there must be no active transactions or tables locked with LOCK TABLES. If any errors occur during a RENAME TABLE, the statement fails and no changes are made. If a table has triggers, attempts to rename the table into a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. This procedure disables binary logging during its execution by manipulating the ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engine-setting.html
You can set the default storage engine for the current session by setting the default_storage_engine variable: SET default_storage_engine=NDBCLUSTER; The storage engine for TEMPORARY tables created with CREATE TEMPORARY TABLE can be set separately ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-values.html
row *************************** Name: NodeId Node: 2 Type: unsigned Default: Minimum: 1 Maximum: 48 Required: Y Current: 2 *************************** 2. row *************************** Name: HostName Node: 2 Type: string Default: localhost Minimum: ... The config_values table, implemented in NDB 7.5.0, provides information about the current state of node configuration parameter ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
For example, you might see an error like this: bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory If this happens, you must install the missing libraries manually or with your ...
https://dev.mysql.com/doc/refman/5.7/en/server-loadable-functions.html
MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove capabilities. MySQL Enterprise Edition includes a ...For ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
SHOW SLAVE HOSTS should be executed on a server that acts as a replication source. This is the server ID of the server on which SHOW SLAVE HOSTS is executed, so this same value is listed for each row in the result. SHOW SLAVE HOSTS Displays a list ...