Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning-monitoring.html
The information in these tables is system-wide: it summarizes the compression statistics across all compressed tables in your database. It involves relatively low overhead on the server, so you might query it periodically on a production server to ... Overall application performance, CPU and I/O utilization and the size of disk files are good indicators of how effective compression is for your ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-source.html
The procedure for doing this is almost identical to the procedure used to compile the standard MySQL Server binaries for Windows, and uses the same tools. However, there are two major differences: MySQL NDB Cluster 8.4 is built from the MySQL Server ... Oracle provides precompiled NDB Cluster binaries for Windows which should be adequate for most ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect security. Access control and ...These include choosing good passwords, not granting unnecessary privileges to users, ensuring application security by preventing SQL injections and data corruption, and ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
If you do not have GNU tar on your system, install it with the following command: pkg install archiver/gnu-tar You should mount any file systems on which you intend to store InnoDB files with the forcedirectio option. If you would like MySQL to ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
The server executes the plugin's deinitialization function and removes the row for the plugin from the mysql.plugin system table, so that subsequent server restarts do not load and initialize the plugin. UNINSTALL PLUGIN plugin_name This statement ...plugin_name must be the name of some plugin that is listed in the mysql.plugin ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location. Limited number of ports Windows systems have about 4,000 ports ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
During a hot backup of a huge database (say, in the order of terabytes), huge redo log files could be generated on the server when the backup is in progress. As the redo log files grow faster than they can be processed by mysqlbackup, the backup ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-0.html
MySQL NDB Cluster 8.4.0 is a new development release of NDB 8.4, based on MySQL Server 8.4 and including features in version 8.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster releases. (Bug #36004838) ...NDB Cluster 8.4 source code and binaries can be obtained from ...