PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.3Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Each status variable summary table has one or more grouping columns to indicate how the table aggregates status values: status_by_account has USER, HOST, and VARIABLE_NAME columns to summarize status variables by account. Note The value of the ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation.html
Note MySQL 5.7 supports Solaris 11 (Update 3 and later). MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG format, see Section 2.7.1, “Installing MySQL on Solaris Using a ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
A subquery can contain many of the keywords or clauses that an ordinary SELECT can contain: DISTINCT, GROUP BY, ORDER BY, LIMIT, joins, index hints, UNION constructs, comments, functions, and so on. All subquery forms and operations that the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io-type.html
These views summarize file I/O, grouped by host and event type. By default, rows are sorted by host and descending total I/O latency. The host_summary_by_file_io_type and x$host_summary_by_file_io_type views have these columns: host The host from ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-file-io.html
By default, rows are sorted by descending total file I/O latency. The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...