MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 201 to 210 of 1125 total results

4.2.4 Connecting to the MySQL Server Using Command Options

https://dev.mysql.com/doc/refman/5.7/en/connecting.html

If named-pipe connections are not supported or if the user making the connection is not a member of the Windows group specified by the named_pipe_full_access_group system variable, an error occurs. If the server was not started with the named_pipe ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...

21.5.24.2 Restoring to a different number of data nodes

https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html

Note When changing the total number of LCP threads or LQH threads per node group, you should recreate the schema from backup created using mysqldump. In NDB 7.5.2 and later, this step is necessary only if the total number of LCP threads or LQH ...

11.3.4 The BLOB and TEXT Types

https://dev.mysql.com/doc/refman/5.7/en/blob.html

You can make more bytes significant in sorting or grouping by increasing the value of max_sort_length at server startup or runtime. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of ...

14.12.2 File Space Management

https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html

The pages are grouped into extents of size 1MB for pages up to 16KB in size (64 consecutive 16KB pages, or 128 8KB pages, or 256 4KB pages). The data files that you define in the configuration file using the innodb_data_file_path configuration ...

25.12.15.4 Transaction Summary Tables

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html

row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 ... The ...

8.2.1.2 Range Optimization

https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html

The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...

6.2 Access Control and Account Management

https://dev.mysql.com/doc/refman/5.7/en/access-control.html

MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...

6.4.5.6 Reading Audit Log Files

https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html

The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log files. (This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON ...

10.3.6 Character String Literal Character Set and Collation

https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html

Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...

A.16 MySQL 5.7 FAQ: InnoDB Change Buffer

https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html

What types of operations modify secondary indexes and result in change buffering? A.16.2. How much space does InnoDB use for the change buffer? A.16.5. How do I determine the current size of the change buffer? A.16.6. Where can I find additional ...

Displaying 201 to 210 of 1125 total results