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/innodb-online-ddl-performance.html
Online DDL and Metadata Locks Online DDL operations can be viewed as having three phases: Phase 1: Initialization In the initialization phase, the server determines how much concurrency is permitted during the operation, taking into account storage ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Microsoft Windows. You can stop the ... The MySQL server can be started manually from the command ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config-insert-set-user.html
For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
The following sections describe how to add user-defined collations of the first two types to existing character sets. Summary of the procedure for adding a new user-defined collation: Choose a collation ID. The instructions here cover only ... A ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
(Bug #11758581, Bug #50801) MASTER_USER and MASTER_PASSWORD are the user name and password of the account to use for connecting to the source. The password used for a replication user account in a CHANGE MASTER TO statement is limited to 32 ...] ...
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them. Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute ... You can use the TEMPORARY keyword when creating a ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir Logical Downgrade Logical downgrade involves using mysqldump to dump all tables from the new MySQL version, and then loading the dump file into ... This section describes how to downgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
For example, Oracle Database users are familiar with querying tables in the Oracle data dictionary. INFORMATION_SCHEMA and Privileges For most INFORMATION_SCHEMA tables, each MySQL user has the right to access them, but can see only the rows in the ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
Undo logs that reside in the temporary tablespace are used for transactions that modify data in user-defined temporary tables. An undo log is a collection of undo log records associated with a single read-write transaction. An undo log record ...