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/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/creating-ssl-rsa-files-using-mysql.html
They can be enabled at startup and inspected but not set at runtime. For files generated by the server, if the resulting CN values exceed 64 characters, the _suffix portion of the name is omitted. SSL files created by the server or by ...For some ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set ...
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/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/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/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 ...