PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Today, MySQL Server and many other modern database systems offer a wide range of outer join types. MySQL Server supports multiple-table DELETE statements ...Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these techniques rather than to use ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? A.1.5. Which version of MySQL is production-ready (GA)? MySQL 9.6, 8.4, and 8.0 are actively supported for production use. MySQL 8.0 achieved General Availability (GA) ...Does MySQL have a NOW() function with fractions of seconds? ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-tcp-definition-direct.html
Setting up a cluster using direct connections between data nodes requires specifying explicitly the crossover IP addresses of the data nodes so connected in the [tcp] section of the cluster config.ini file. In the following example, we envision a ...The cluster as a whole resides on the 172.23.72.* subnet of a ...