PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
(This is the first table in the EXPLAIN output that does not have a const join type.) The query has different ORDER BY and GROUP BY expressions. (The resulting sort order may be completely different from the order for ABS(a), of course.) SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-information-schema-tables.html
They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information about thread pool thread group states TP_THREAD_GROUP_STATS: Thread group statistics TP_THREAD_STATE: Information about thread pool thread states Rows in these ... The following sections describe the INFORMATION_SCHEMA tables associated with the thread pool plugin (see Section 5.5.3, “MySQL Enterprise Thread ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
mysqld_safe reads options from the [mysqld], [server], [mysqld_safe], and [safe_mysqld] groups. An embedded MySQL server usually reads options from the [server], [embedded], and [xxxxx_SERVER] groups, where xxxxx is the name of the application into ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
index_hint: USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) index_list: index_name [, index_name] ... To influence index usage for sorting or grouping rows, use ... Index hints give the optimizer information about how to choose indexes during query ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
mysql> CREATE TABLESPACE myts -> ADD DATAFILE 'mydata-1.dat' -> USE LOGFILE GROUP mylg -> ENGINE=NDB; You must remove all data files from the tablespace using ALTER TABLESPACE, as shown here, before it can be dropped: mysql> ALTER TABLESPACE myts -> ... DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
MySQL Server, and Group Replication, which enables a set of MySQL instances to provide high-availability. InnoDB Cluster provides an alternative, easy to use programmatic way to work with Group Replication. The following diagram shows an overview of ... This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables. These do not fall into any of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_flush_log_at_timeout allows the timeout period between flushes to be increased in order to reduce flushing and avoid impacting performance of binary log group commit. innodb_log_file_size Command-Line Format --innodb-log-file-size=# System ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
--defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String Read not only the usual option groups, but also groups with the usual names and a suffix of str. If this option is given as --defaults-group-suffix=_other, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...