Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster data. If no computer or host name is provided, any host can use this SQL or API ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
For example, it is possible to permit an account to modify any table except those in the mysql system schema. To change the value for the running MySQL instance without having it carry over to subsequent restarts, use the GLOBAL keyword rather than ... It is possible to grant privileges that apply globally if the partial_revokes system variable is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...Since changing ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-installation-windows-path.html
To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable: On the Windows desktop, right-click the My Computer icon, and select Properties. The new PATH value ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
The partition information is displayed if you specify the -v or --verbose option when viewing the binary log using mysqlbinlog. However, when a limiting condition making use of the partitioning key is added to the query, you can see that only those ... This section discusses obtaining information about existing partitions, which can be done in a number of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr DROP PARTITION p2; Query OK, 0 rows affected (0.03 sec) Note The NDBCLUSTER storage engine does not support ALTER TABLE ... You can see that this is the case by ...
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
MySQL Perl support requires that you have installed MySQL client programming support (libraries and header files). If you install MySQL from RPM files on Linux, be sure to install the developer RPM as well. For example: $> perl -MCPAN -e shell ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A MySQL server installed as a service can also be controlled from the command line using ...The Services utility (the Windows Service Control Manager) can be found in the Windows Control ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/configuring-production-instances.html
Depending on the way MySQL Shell is connected to the instance, and the version of MySQL running on the instance, you can make these changes permanent by persisting them to a remote instance's option file, see Section 6.2.3, “Persisting Settings”. The options dictionary can contain the following: mycnfPath - the path to the MySQL option file of the ... AdminAPI provides the dba.configureInstance() function that checks if an instance is suitably configured for InnoDB ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-remove.html
Check the status of the whole deployment using AdminAPI's clusterSet.status() function in MySQL Shell. For example: mysql-js> myclusterset.status({extended: 1}) For an explanation of the output, see Section 9.7, “InnoDB ClusterSet Status and ...