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/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. The maximum index width for ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
The maximum number of channels that can be created on one replica in a multi-source replication topology is 256. The error codes and messages that are issued when multi-source replication is enabled specify the channel that generated the error. In ...
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/floating-point-types.html
For maximum portability, code requiring storage of approximate numeric data values should use FLOAT or DOUBLE PRECISION with no specification of precision or number of digits. The FLOAT and DOUBLE types represent approximate numeric data values.
https://dev.mysql.com/doc/refman/5.7/en/replication-implementation.html
The replica also executes the events from the binary log that it receives. Replication is based on the replication source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. The binary log serves as ...
https://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/5.7/en/channels-startup-options.html
--slave_net-timeout=N This value is set per channel, so that each channel waits for N seconds to check for a broken connection. --max-relay-log-size=size Maximum size of the individual relay log file for each channel; after reaching this limit, the ... This section describes startup options which are impacted by the addition of replication ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-debian.html
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels: The MySQL APT Repository. This is the preferred method for installing MySQL on Debian-like ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
To execute RENAME TABLE, there must be no active transactions or tables locked with LOCK TABLES. If any errors occur during a RENAME TABLE, the statement fails and no changes are made. If a table has triggers, attempts to rename the table into a ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. If your intention is to use MySQL in a traditional (SQL) way, this chapter is probably not relevant to you. Important ...