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/charset-unicode-utf32.html
utf32 takes twice as much space as ucs2 and more space than utf16, but utf32 has the same advantage as ucs2 that it is predictable for storage: The required number of bytes for utf32 equals the number of characters times 4. The utf32 character set ...
https://dev.mysql.com/doc/refman/5.7/en/uninstall-plugin.html
The server executes the plugin's deinitialization function and removes the row for the plugin from the mysql.plugin system table, so that subsequent server restarts do not load and initialize the plugin. UNINSTALL PLUGIN plugin_name This statement ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-data-definition-statements.html
In a Group Replication topology, care needs to be taken when executing data definition statements also commonly known as data definition language (DDL). Given that MySQL does not support atomic or transactional DDL, one cannot optimistically ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
It is now time to expand the group by adding the other two servers configured previously. 17.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. mysql> START GROUP_REPLICATION; ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
No warnings or errors are issued by the server if a variable has the wrong type or has previously not been assigned a value. This also means the user is fully responsible for any typographical errors, since no warnings are given if (for example) ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-unicode-uca.html
This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml file. It uses a subset of the Locale Data Markup Language (LDML) ...
https://dev.mysql.com/doc/refman/5.7/en/gis-geometry-class-hierarchy.html
The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point (instantiable) Curve (noninstantiable) LineString (instantiable) Line LinearRing Surface (noninstantiable) Polygon (instantiable) GeometryCollection (instantiable) ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-optimization.html
To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL statement.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering-names.html
Names given for filtering operations can be as specific or general as required. For example, to select all file I/O instruments, it is better to use a pattern that includes the entire instrument name prefix: ... WHERE NAME LIKE 'wait/io/file/%'; ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs.html
A replica server creates several repositories of information to use for the replication process: The relay log, which is written by the replication I/O thread, contains the transactions read from the replication source server's binary log. The ...