PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/en/replication-multi-source-adding-binlog-master.html
These steps assume that binary logging is enabled on the source (which is the default), the replica is using TABLE based replication applier metadata repositories (which is the default in MySQL 8.0), and that you have enabled a replication user and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-start-replica.html
Once you have added channels for all of the replication sources, issue a START REPLICA (or before MySQL 8.0.22, START SLAVE) statement to start replication. When you have enabled multiple channels on a replica, you can choose to either start all ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-rawdata.html
To guarantee the integrity of the files that are copied, backing up the raw data files on your MySQL replica should take place while your replica server is shut down. If the MySQL server is still running, background tasks may still be updating the ...With InnoDB, these problems should be resolved during crash recovery, but since the replica server can be shut down during the backup process without affecting the execution of the source it makes sense to take advantage of this ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-installation.html
This section describes how to install MySQL Enterprise Thread Pool. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). Thread Pool Installation ...For general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
For example, to remove the limit on how many times per hour francis can connect, use this statement: mysql> ALTER USER 'francis'@'localhost' WITH MAX_CONNECTIONS_PER_HOUR 0; As mentioned previously, the simultaneous-connection limit for an account ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...This limits ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
Checking Version Compatibility The FOR UPGRADE option checks whether the named tables are compatible with the current version of MySQL. Otherwise, if there is a possible incompatibility, the server runs a full check on the table (which might take ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
Use SHOW ENGINE PERFORMANCE_SCHEMA STATUS to inspect the internal operation of the Performance Schema code: mysql> SHOW ENGINE PERFORMANCE_SCHEMA STATUS\G ... An NdbTransaction is created each time a table schema operation (such as CREATE TABLE or ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
In that situation, to re-create the group, it must be started by bootstrapping as if it was being started for the first time. Edit the MySQL Server configuration file (typically named my.cnf on Linux and Unix systems, or my.ini on Windows systems) ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE ... The ...