PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. To secure the user credentials, you can require SSL for connections ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
The namespace enables different applications to use the same lock names without colliding by creating locks in separate namespaces. Locking Service Monitoring The locking service is implemented using the MySQL Server metadata locks framework, so you ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. To use either statement, you must be the user named as the routine DEFINER, have the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
ssl: A directory that contains the certificate and key files required to establish a secure connection with the KMIP back end: CA.pem, cert.pem, and key.pem. The following procedure briefly summarizes the process of setting up keyring_okv for use ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
The string must be a suitable length for the Primary Account Number, but is not otherwise checked. Warning Values returned from gen_rnd_canada_sin() should be used only for test purposes, and are not suitable for publication. Warning Values returned ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.0/en/examples.html
Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Here are examples of how to solve some common problems with MySQL. Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-memory.html
If you are going to use myisamchk on very large tables, you should first decide how much memory you want it to use. This space is not needed if you do a repair with --quick; in this case, only the index file is re-created. This space must be ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-rolling-restart.html
Create a backup using the ndb_mgm client START BACKUP command prior to performing the restart. Use mysqldump to create a backup prior to the upgrade; afterward, restore the dump using LOAD DATA. To free memory previously allocated to a table by ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-loadable-function-information.html
The Performance Schema user_defined_functions table contains information about the currently installed loadable functions: SELECT * FROM performance_schema.user_defined_functions; The mysql.func system table also lists installed loadable functions, ...This difference makes user_defined_functions preferable to mysql.func for checking which loadable functions are ...