PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
--show-slave-auth-info Command-Line Format --show-slave-auth-info[={OFF|ON}] Type Boolean Default Value OFF Display replica user names and passwords in the output of SHOW SLAVE HOSTS on the source server for replicas started with the --report-user ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
DEFINER The account of the user who created the view, in 'user_name'@'host_name' format. This column has most of what you see in the Create Table column that SHOW CREATE VIEW produces. Suppose that the original statement was: CREATE VIEW v AS SELECT ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names. Value Meaning 0 Table and database names are stored on disk using the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
In a newly created system tablespace, InnoDB allocates space starting from the first data file. To avoid the issues that come with storing all tables and indexes inside the system tablespace, you can enable the innodb_file_per_table configuration ...
https://dev.mysql.com/doc/refman/5.7/en/server-shutdown.html
For example, a user with the SHUTDOWN privilege can execute a mysqladmin shutdown command. Depending on how shutdown was initiated, the server might create a thread to handle the shutdown process. If shutdown was requested by a client, a shutdown ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
-DSYSTEMD_PID_DIR=dir_name The name of the directory in which to create the PID file when MySQL is managed by systemd. -DREPRODUCIBLE_BUILD=bool For builds on Linux systems, this option controls whether to take extra care to create a build result ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. Create a simple InnoDB temporary table: mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; Query ...It ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. PARTITION BY KEY are similar to those for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
Because local variables are in scope only during stored program execution, references to them are not permitted in prepared statements created within a stored program. An event may not be created, altered, or dropped from within a stored program, if ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...