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/mysql-cluster-programs-ndb-mgmd.html
Otherwise—that is, if you wish to disable configuration caching for a management server that has already created a configuration cache—you must stop the management server, delete any existing configuration cache files manually, then restart the ... The management server is the process that reads the cluster configuration file and distributes this information to all nodes in the cluster that request ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
To specify the password for encrypting the keyring data file, set the keyring_encrypted_file_password system variable. (The password is mandatory; if not specified at server startup, keyring_encrypted_file initialization fails.) The ...The ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
Before you begin, you should change location to the database directory and check the permissions of the table files. On Unix, make sure that they are readable by the user that mysqld runs as (and to you, because you need to access the files you are ...This section is for the cases where a table check fails (such as those described in Section 7.6.2, “How to Check MyISAM Tables for Errors”), or you want to use the extended features that myisamchk ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For SET or ENUM values, the cast operation causes the underlying numeric value to be used. mysql> SELECT student_name, MIN(test_score), MAX(test_score) FROM student GROUP BY student_name; For MAX(), MySQL currently compares ENUM and SET columns by ... This section describes aggregate functions that operate on sets of ...If you use an aggregate function in a statement ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. A candidate object is contained in a target object if ...
https://dev.mysql.com/doc/refman/5.7/en/table-cache.html
If table_open_cache is set too high, MySQL may run out of file descriptors and exhibit symptoms such as refusing connections or failing to perform queries. MySQL is multithreaded, so there may be many clients issuing queries for a given table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the replication source servers using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication metadata repositories, and provisioned the ...Use ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
When binary log events were written in row-based format and you want to read or recover from a replication or database failure you can use this command to read contents of the binary log. For other scenarios, setting slave_exec_mode to STRICT is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-basics.html
Because it is ubiquitous, most users employ TCP/IP over Ethernet for NDB Cluster. The MySQL Cluster Manager client also supports commands for getting and setting the values of most node configuration parameters as well as mysqld server options and ...NDB Cluster's NDB storage engine contains a complete set of data, dependent only on other data within the cluster ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
If the replication I/O thread state says Connecting to master, check the following: Verify the privileges for the user being used for replication on the source. If you have followed the instructions but your replication setup is not working, the ...