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/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-file-by-bytes.html
total The total number of bytes read and written for the file. These views summarize global I/O consumers to display amount of I/O, grouped by file. By default, rows are sorted by descending total I/O (bytes read and written). The ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-formats.html
The logging format can also be set or limited by the storage engine being used. The server uses several logging formats to record information in the binary log. The exact format employed depends on the version of MySQL being used. There are three ...In row-based logging, the source writes events to the binary log that indicate how individual table rows are ...
https://dev.mysql.com/doc/refman/5.7/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); .
https://dev.mysql.com/doc/refman/5.7/en/data-masking-elements.html
A set of loadable functions provides an SQL-level API for performing masking and de-identification operations. MySQL Enterprise Data Masking and De-Identification is based on a plugin library that implements these elements: A server-side plugin ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption.html
MySQL Enterprise Edition includes a set of encryption functions based on the OpenSSL library that expose OpenSSL capabilities at the SQL level. Note MySQL Enterprise Encryption is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/foreign-key-optimization.html
That way, each small table can have a primary key for fast lookups of its data, and you can query just the set of columns that you need using a join operation. Depending on how the data is distributed, the queries might perform less I/O and take up ... If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the numeric ID column from the main ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-multipoint.html
On a city map, a MultiPoint could represent the outlets for a ticket office. A MultiPoint is a geometry collection composed of Point elements. MultiPoint Examples On a world map, a MultiPoint could represent a chain of small islands. A MultiPoint ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-shutdown-restart.html
To restart the cluster on Unix platforms, run these commands: On the management host (198.51.100.10 in our example setup): $> ndb_mgmd -f /var/lib/mysql-cluster/config.ini On each of the data node hosts (198.51.100.30 and 198.51.100.40): $> ndbd Use ...On Windows platforms, assuming that you have installed the SQL node as a Windows service, you can use SC STOP service_name or NET STOP ... To shut down the cluster, enter the following command in a shell on the ...