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/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. The header for a row takes up one to three bytes depending on the biggest row in the table. For example, a BIGINT column (eight bytes) can be stored as a ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-installation.html
For general information about installing or uninstalling plugins and loadable functions, see Section 5.5.1, “Installing and Uninstalling Plugins”, and Section 5.6.1, “Installing and Uninstalling Loadable Functions”. If necessary, configure ... This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable ...
https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...A ...
https://dev.mysql.com/doc/refman/5.7/en/gis-geometry-class-hierarchy.html
They define a common set of methods for their subclasses and are included for extensibility. The base Geometry class has subclasses for Point, Curve, Surface, and GeometryCollection: Point represents zero-dimensional objects. GeometryCollection has ... The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point (instantiable) Curve (noninstantiable) LineString (instantiable) Line LinearRing Surface (noninstantiable) Polygon (instantiable) GeometryCollection (instantiable) MultiPoint (instantiable) MultiCurve (noninstantiable) MultiLineString (instantiable) MultiSurface (noninstantiable) MultiPolygon (instantiable) It is not possible to create objects in noninstantiable ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-fine-tuning-the-group-communication-thread.html
By configuring this wait to be a little longer (doing an active wait) before actually going to sleep can prove to be beneficial in some cases. This is because the alternative is for the operating system to switch out the GCT from the processor and ... The group communication thread (GCT) runs in a loop while the Group Replication plugin is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
InnoDB file format settings do not apply to tables stored in general tablespaces. As InnoDB evolves, data file formats that are not compatible with prior versions of InnoDB are sometimes required to support new features. To help manage ...Now that ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-issues.html
For example, start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. In many cases, MySQL can calculate the best possible query plan, ... MySQL uses a cost-based optimizer to determine the best way to resolve a ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
When using COMPACT row format (the default InnoDB format) and variable-length character sets, such as utf8 or sjis, CHAR(N) columns occupy a variable amount of space, but still at least N bytes. The reorganized tables require less disk I/O to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. Changes to this code occur often, which also affects the set of instruments. As described earlier, it is possible to find ...It is not practical to list all the instruments because there are hundreds of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-account-connect-attrs-table.html
For descriptions of common attributes, see Section 25.12.9, “Performance Schema Connection Attribute Tables”. The session_account_connect_attrs table contains connection attributes only for the current session, and other sessions associated with ... Application programs can provide key-value connection attributes to be passed to the server at connect ...