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/bug-reports.html
The normal way to report bugs is to visit http://bugs.mysql.com/, which is the address for our bugs database. Bugs posted in the bugs database at http://bugs.mysql.com/ that are corrected for a given release are noted in the release notes. To ...We ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
For example: mysql> SET GLOBAL innodb_buffer_pool_size=402653184; Note The buffer pool size must be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances. For additional information about configuring buffer pool size ... You can configure InnoDB buffer pool size offline or while the server is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to monitor multi-source replication, see Section 16.1.5, “MySQL Multi-Source Replication”. This channel is ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. For further details on recognition of ...Reserved words are permitted as identifiers if you quote them as described in Section 9.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
The default MySQL setting AUTOCOMMIT=1 can impose performance limitations on a busy database server. This issue is expected to be infrequent with the default setting innodb_change_buffering=all, which allows update and delete operations to be cached ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...To minimize the ...
https://dev.mysql.com/doc/refman/5.7/en/native-pluggable-authentication.html
This section describes mysql_native_password, which implements authentication against the mysql.user system table using the native password hashing method. MySQL includes two plugins that implement native authentication; that is, authentication ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
For a RANGE partition, it contains the value set in the partition's VALUES LESS THAN clause, which can be either an integer or MAXVALUE. TABLE_SCHEMA The name of the schema (database) to which the table belongs. PARTITION_EXPRESSION The expression ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
A more flexible method for query optimization enables the user to control how exhaustive the optimizer is in its search for an optimal query evaluation plan. If you are unsure of what a reasonable value is for optimizer_search_depth, this variable ... The task of the query optimizer is to find an optimal plan for executing an SQL ...The general idea is that the fewer plans ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
USER_LOCK_WAITS The number of THD_WAIT_USER_LOCK waits for a special lock constructed by the user thread. QUERIES_QUEUED The number of statements received that were queued for execution. For InnoDB, this most likely means deteriorating performance ...The TP_THREAD_GROUP_STATS table has these columns: TP_GROUP_ID The thread group ...