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/cost-model.html
Cost Model General Operation The Cost Model Database Making Changes to the Cost Model Database Cost Model General Operation The configurable optimizer cost model works like this: The server reads the cost model tables into memory at startup and uses ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. This section describes the basic principles of entering queries, using ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
Do not query this table on a production system unless you are aware of the performance impact and have determined it to be acceptable. This is an identifier to distinguish between multiple buffer pool instances. FIX_COUNT The number of threads using ... The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
This means that they are not started until there is a need to wake a new thread and there is no consumer thread. This is where most threads end up when the thread group has created more threads than needed for normal operation. In this case, they go ... The TP_THREAD_GROUP_STATE table has one row per thread group in the thread ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. These properties make this compression technique unsuitable for use in an update-intensive database system. This compression algorithm is mature, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...In other words, every unique key on the table must use every column in the table's partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. In this case, you need to determine the latest ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
To do this, use the --install-manual option rather than the --install option: C:\> "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" --install-manual Removing the service To remove a server that is installed as a service, first stop it if it is ...This command invokes the MySQL administrative utility mysqladmin to connect to the server and tell it to shut ... On Windows, the recommended way to run MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
What character set should the server translate statements to after receiving them? To determine this, the server uses the character_set_connection and collation_connection system variables: The server converts statements sent by the client from ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
If a statement raises multiple conditions, this part of the diagnostics area has a condition area for each one. If a statement raises no conditions, this part of the diagnostics area is empty. For a statement that produces three conditions, the ...