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/security-against-attack.html
For example: [mysqld] user=mysql This causes the server to start as the designated user whether you start it manually or by using mysqld_safe or mysql.server. If the connection between the client and the server goes through an untrusted network, and ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40% to 50%. (This is also true if the InnoDB table is partitioned.) AVG_ROW_LENGTH The average row length. Refer to the notes ...The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/nested-join-optimization.html
This is a conservative extension if we consider each comma in a list of table_reference items as equivalent to an inner join. Suppose that a join query over 3 tables T1,T2,T3 has this form: SELECT * FROM T1 INNER JOIN T2 ON P1(T1,T2) INNER JOIN T3 ...The following discussion refers to the join syntax described in Section 13.2.9.2, “JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous transactions. This procedure does not require taking the server offline and is suited to use in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. The series is calculated like this: auto_increment_offset + N × auto_increment_increment where N is a positive integer value in the ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 23.4, “Using the Event Scheduler”. Execute At For a one-time event, this is the ...It requires the EVENT privilege for the database from which the events are to be ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
For guidelines on setting this variable, see Section 5.5.3.4, “Thread Pool Tuning”. This differs from the default thread-handling model that associates one thread with one connection such that a given thread executes all statements from its ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
For partitioned tables, both the single-single and multiple-table forms of this statement support the use of a PARTITION clause as part of a table reference. This option takes a list of one or more partitions or subpartitions (or both). This affects ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. Furthermore, given that changes are propagated and applied in row-based format, this means that they ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
See MySQL Cluster Manager 1.4.8 User Manual, for more information about this tool. When I run the SHOW command in the NDB Cluster management client, I see a line of output that looks like this: A.10.8. The loading process terminates prematurely and ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...