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/create-user.html
Encrypted connections can be used, at the client's option, if the client has the proper certificate and key files. CREATE USER 'jeffrey'@'localhost' REQUIRE X509; For accounts with REQUIRE X509, clients must specify the --ssl-key and --ssl-cert ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
St Who DB ConnID Dur microsec Query 0 root@::ffff:198.51.100.108 test 31 3495 select * from t1 limit 1000000 Net read: 0 bytes (0 ms) write: 10000075 bytes (1220 ms) 5.8.4.1.14 Keycache Probes The keycache probes are triggered when using the index ... MySQL supports the following static probes, organized into groups of ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-function-reference.html
Table 6.36 MySQL Enterprise Encryption Functions Name Description asymmetric_decrypt() Decrypt ciphertext using private or public key asymmetric_derive() Derive symmetric key from asymmetric keys asymmetric_encrypt() Encrypt cleartext using private ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
ON DUPLICATE KEY UPDATE statements, but if a duplicate-key violation occurs, the statement fails with an error. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
Consequently, the query reads every row of the table, evaluates the predicate for each row, and outputs all rows for which the primary key matches the random value. This UPDATE statement uses a nondeterministic function to select rows to be ...A ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
Analyzing The thread is calculating a MyISAM table key distributions (for example, for ANALYZE TABLE). manage keys The server is enabling or disabling a table index. Repair with keycache The repair code is using creating keys one by one through the ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
You can prevent the use of other storage engines by setting the disabled_storage_engines system variable on group members, for example: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Primary Keys. Every table that is to be ...
https://dev.mysql.com/doc/refman/5.7/en/index-preloading.html
If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to preload the key cache with index blocks before starting to use it. Preloading enables you to ...Although the blocks stay in the cache, because there are enough buffers for all of them, they are fetched from disk in random order, and not ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
row *************************** id: 1 select_type: SIMPLE table: VIEWS type: ALL possible_keys: NULL key: TABLE_SCHEMA,TABLE_NAME key_len: NULL ref: NULL rows: NULL Extra: Using where; Open_frm_only; Scanned 0 databases Use of constant database and ... Applications that monitor databases may make frequent use of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
MySQL ensures that unique key values remain unique within that MyISAM table, but not over all the underlying tables in the collection. The two key facts are: REPLACE can detect unique key violations only in the underlying table to which it is going ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...