PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
(One use of this is in the NDB implementation of the REPLACE SQL statement.) The tot_key_refs column shows the number of key operations refused by the LDM. The operations_per_fragment table provides information about the operations performed on ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
Database administrators should use the following guidelines to keep passwords secure. A user who has access to modify the plugin directory (the value of the plugin_dir system variable) or the my.cnf file that specifies the plugin directory location ...MySQL stores passwords for user accounts in the mysql.user system ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Consider these statements: SELECT * FROM orders WHERE customer_id=10 AND quantity>20 SELECT * FROM orders WHERE customer_id = 20 AND quantity > 100 To normalize these statements, the parser replaces data values by ? and adjusts whitespace. The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
uuid: hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh h: [0-9|A-F] interval: n[-n] (n >= 1) mysql.gtid_executed Table GTIDs are stored in a table named gtid_executed, in the mysql database. To save space, the MySQL server compresses the mysql.gtid_executed ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
An example use case for this action is when you are restoring a backup of one or more databases on a server, but you do not have the relevant binary logs containing the transactions on the server. The MySQL Server system variables described in this ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
How do I import an existing MySQL database into an NDB Cluster? A.10.28. What do “NDB” and “NDBCLUSTER” mean? “NDB” stands for “Network Database”. There must be sufficient memory on machines used for data nodes to hold each node's ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
If you upgrade in place, the process replaces the modified files. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
Parameters in the message template are replaced with values that apply to a specific error occurrence: Identifiers such as table or column names use UTF-8 internally so they are copied as is. This section describes how the MySQL server uses ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...