Search Results
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. An “account” in this context corresponds to a row in the mysql.user system table. The following ...This ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
Note that before starting mysqld with the general query log enabled, you should check all your tables with myisamchk. If mysqld dies or hangs, you should start mysqld with the general query log enabled. When mysqld dies again, you can examine the ...If this works, you should also test all complicated queries that did not ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and ...A dump file can be used in several ways: As a backup to enable data recovery in case of data ...
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. For SHOW VARIABLES, if you specify neither GLOBAL nor SESSION, MySQL returns SESSION values. Section 7.1.8, “Server System Variables”, describes the meaning of these ...
https://dev.mysql.com/doc/refman/8.4/en/verifying-md5-checksum.html
After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages. The correct MD5 checksum is listed on the downloads page for each MySQL product; you should compare it ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-system-monitoring.html
We use MySQL Shell in Python mode, and the \sql command which enables you to issue SQL statements without changing to SQL mode. The \sql command is used in the same way if you are using MySQL Shell in JavaScript mode. Issue: mysql-py> \sql SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
Disabling detached XA transactions is not recommended for a MySQL server instance used in group replication; see Server Instance Configuration, for more information. An XA transaction progresses through the following states: Use XA START to start ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encryption.html
In order to enhance security for backed up data, MySQL Enterprise Backup provides encryption for single-file backups. Supply the key to mysqlbackup with the --key option, or paste the key into a key file and supply the file's pathname to ...The ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.dfs-san.html
When system administrators attempt to set up MySQL and MySQL Enterprise Backup in an environment that uses a distributed file system (DFS) or a storage access network (SAN), the MySQL server, the server's data directory, MySQL Enterprise Backup, ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-delete-cluster.html
delete cluster [--removedirs] cluster_name This command deletes the cluster named cluster_name, removing it from the list of clusters managed by MySQL Cluster Manager. delete cluster does not remove any MySQL NDB Cluster binaries from hosts.