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/partitioning-overview.html
There are no plans at this time to introduce vertical partitioning into MySQL. In addition, MAX_ROWS and MIN_ROWS can be used to determine the maximum and minimum numbers of rows, respectively, that can be stored in each partition. This section ...
https://dev.mysql.com/doc/refman/5.7/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/5.7/en/timezone-problems.html
If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. You can set the time zone for the server with the --timezone=timezone_name option to mysqld_safe. This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
The index TYPE value indicates the type of index (1 = Clustered Index, 0 = Secondary index). The CLUST_INDEX_SIZE and OTHER_INDEX_SIZE fields report the number of pages on disk that store clustered and secondary indexes for the table, respectively.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
rpl_semi_sync_master_timeout Command-Line Format --rpl-semi-sync-master-timeout=# System Variable rpl_semi_sync_master_timeout Scope Global Dynamic Yes Type Integer Default Value 10000 Minimum Value 0 Maximum Value 4294967295 Unit milliseconds A ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-errors.html
If that happens on the source, the replica expects execution of the statement to result in the same error code. If a statement produces the same error (identical error code) on both the source and the replica, the error is logged, but replication ...To address the issue, connect to the replica manually and determine the cause of the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-time.html
Given a Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the value, the units part is ps (picoseconds), ns ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. After an unexpected halt of a replica, upon restart the ...This ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
A general event with the general_command.str field set to Query or Execute contains general_sql_command.str set to a value that specifies the type of SQL command: alter_db, alter_db_upgrade, admin_commands, and so forth. WHERE (for tables referenced ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
This is also the case when using ndbmtd with MaxNoOfExecutionThreads set to 3 or less. (You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are ... This ...