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/string-comparison-functions.html
Normally, if any expression in a string comparison is case-sensitive, the comparison is performed in case-sensitive fashion. For more information about that option, see Section 4.5.1, “mysql — The MySQL Command-Line Client”. For example, it ...
https://dev.mysql.com/doc/refman/5.7/en/using-gdb-on-mysqld.html
In this case, you should set the following environment variable in the shell before starting gdb: LD_ASSUME_KERNEL=2.4.1 export LD_ASSUME_KERNEL When running mysqld under gdb, you should disable the stack trace with --skip-stack-trace to be able to ... On most systems you can also start mysqld from gdb to get more information if mysqld ...With some older gdb ...
https://dev.mysql.com/doc/refman/5.7/en/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...
https://dev.mysql.com/doc/refman/5.7/en/custom-benchmarks.html
A free benchmark suite is the Open Source Database Benchmark, available at http://osdb.sourceforge.net/. In most cases, performance problems turn out to be due to issues of basic database design (for example, table scans are not good under high ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
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 ...