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/privilege-changes.html
If you modify the grant tables indirectly using an account-management statement, the server notices these changes and loads the grant tables into memory again immediately. Any user can connect and perform any operation, which is insecure. If the ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
The metadata in this repository includes the connection configuration, the replication user account details, the SSL settings for the connection, and the file name and position where the replication I/O thread is currently reading from the source's ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...If binary log file position based replication is in use, when the replica restarts, it reads the two ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
Note InnoDB does not open all user tables and associated data files at startup. InnoDB is a transaction-safe (ACID compliant) storage engine with commit, rollback, and crash-recovery capabilities to protect user data. With regard to InnoDB recovery ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html
MySQL Installer automatically installs MySQL Server and additional MySQL products, creates an options file, starts the server, and enables you to create default user accounts. Users should make sure the package has been installed on the system ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
While a thread executes a statement from a user connection, Performance Schema instrumentation accounts thread activity to the user connection. Otherwise, the thread pool considers the statement stalled and starts another thread as a listener thread ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
Conflict resolution in NDB Cluster Replication provides a means of resolving such conflicts by permitting a user-defined resolution column to be used to determine whether or not an update on a given source should be applied on the replica. Some ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes Type Enumeration Default Value FIXED Valid Values FIXEDDYNAMIC In NDB ...
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 ...Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table ... Online DDL improves ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not done. For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ... mysql sends each SQL statement that you issue to the server to be ...
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 ...