PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
Your firewall may be configured on the basis of the application being executed, or the port number used by MySQL for communication (3306 by default). After a fresh installation, if you try to log on to the server as root without using a password, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-views.html
SQL statements are truncated to a maximum display width using format_statement(). The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
PROCESS_COUNT The 10ms interval in which the statement that uses this thread is currently executing. 0 means no statement is executing, 1 means it is in the first 10ms, and so forth. The TP_THREAD_STATE table has one row per thread created by the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-fault-tolerance.html
However, if a second server fails involuntarily, then the group (with one server left) blocks, because there is no majority to reach a decision. MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-server.html
This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations. The following discussion covers these MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/5.7/en/firewall.html
MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against lists of accepted statement patterns. Note MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html
Although it can be tempting to create an indexes for every possible column used in a query, unnecessary indexes waste space and waste time for MySQL to determine which indexes to use. The best way to improve the performance of SELECT operations is ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors occur. To start with, execute myisamchk -s each night on all tables that have been updated during the last 24 hours. If you are performing ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-formats.html
The server uses several logging formats to record information in the binary log. The exact format employed depends on the version of MySQL being used. There are three logging formats: Replication capabilities in MySQL originally were based on ...