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/performance-schema.html
In general, an event could be a function call, a wait for the operating system, a stage of an SQL statement execution such as parsing or sorting, or an entire statement or group of statements. The MySQL Performance Schema is a feature for ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
(In such cases, lsof +L1 may be helpful in identifying large files associated with mysqld.) When sorting (ORDER BY or GROUP BY), MySQL normally uses one or two temporary files. On Unix, MySQL uses the value of the TMPDIR environment variable as the ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
The MySQL server authenticates connection attempts for each account listed in the mysql.user system table using the authentication plugin named in the plugin column. If the plugin column is empty, the server authenticates the account as follows: ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
Note This section describes legacy audit log filtering, which applies under either of these circumstances: Before MySQL 5.7.13, that is, prior to the introduction of rule-based audit log filtering described in Section 6.4.5.7, “Audit Log ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement updates an NDBCLUSTER table. When one or more tables with AUTO_INCREMENT columns ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
This section describes aspects of how the MySQL server manages client connections. Network Interfaces and Connection Manager Threads Client Connection Thread Management Connection Volume Management Network Interfaces and Connection Manager Threads ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
Once you know how to enter SQL statements, you are ready to access a database. Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about them. You can do so by creating ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and server. When you must move information over a ...