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/creating-ssl-rsa-files-using-mysql.html
For some distribution types, such as RPM and DEB packages, mysql_ssl_rsa_setup invocation occurs during data directory initialization. In this case, the MySQL distribution need not have been compiled using OpenSSL as long as the openssl command is ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
SET @ciphertext = asymmetric_encrypt(@algo, 'My secret text', @priv); SET @plaintext = asymmetric_decrypt(@algo, @ciphertext, @pub); Conversely, you can encrypt using the public key and decrypt using the private key. SET @ciphertext = ... To use ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
The functions described in this section are used with GTID-based replication. It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. As such, the GTID sets must always be quoted when used ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-configuration.html
The configuration file should be located in the /etc directory and can be edited using any text editor. (Create the file if it does not exist.) For example: $> vi /etc/my.cnf Note We show vi being used here to create the file, but any text editor ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memoryusage.html
used_pages Number of pages currently used for data memory or index memory by this data node; see text. total Total number of bytes of data memory or index memory available for this data node; see text. total_pages Total number of memory pages ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. You can find more detailed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
Note If you are replicating tables with very large columns (such as TEXT or BLOB columns), --ndb-log-updated-only can also be useful for reducing the size of the binary logs and avoiding possible replication failures due to exceeding ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
The mysqldump command can also generate output in CSV, other delimited text, or XML format. --enable-cleartext-plugin Command-Line Format --enable-cleartext-plugin Introduced 5.7.10 Type Boolean Default Value FALSE Enable the mysql_clear_password ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-numeric.html
If you are using numeric data, it is faster in many cases to access information from a database (using a live connection) than to access a text file. Information in the database is likely to be stored in a more compact format than in the text file, ... For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
SQL statements are expressed as text, such as DELETE FROM t1 or SELECT * FROM t2. If the request is a statement, the statement text is read and given to the parser. For a request read as a statement from the relay log on a replica: Statements in the ...Statement events occur at a high level of the event ...