PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-summary-tables.html
Each socket summary table has one or more grouping columns to indicate how the table aggregates events. This column can be grouped on to isolate, for example, client activity from that of the server listening sockets. These socket summary tables ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-null.html
When using DISTINCT, GROUP BY, or ORDER BY, all NULL values are regarded as equal. Aggregate (group) functions such as COUNT(), MIN(), and SUM() ignore NULL values. The concept of the NULL value is a common source of confusion for newcomers to SQL, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
Note that replication filters cannot be used on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on a consistent state. If a replication ...
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
For example, to specify a directory to be used by MySQL client programs, list it in the [client] group of your option file. The MySQL server has a compiled-in default character set and collation. To change these defaults, use the ...
https://dev.mysql.com/doc/refman/5.7/en/connection-compression-control.html
Compression control does not apply to Group Replication connections, X Protocol connections, or connections for FEDERATED tables. Connections to the server can use compression on the traffic between client and server to reduce the number of bytes ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Group sets of related DML operations into transactions by bracketing them with START TRANSACTION and COMMIT statements. Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
This section describes issues that you may encounter when using the InnoDB memcached plugin. If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open files. One solution is to raise ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. A transaction ID is only needed for a transaction that might perform write operations or locking reads such ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
In most cases, it might take some time for the thread to die because the kill flag is checked only at specific intervals: During SELECT operations, for ORDER BY and GROUP BY loops, the flag is checked after reading a block of rows. KILL [CONNECTION ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
This section provides a simplified outline of the steps involved when NDB Cluster data nodes are started. More complete information can be found in NDB Cluster Start Phases, in the NDB Internals Guide. These phases are the same as those reported in ...