PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
Group Replication does not handle client-side failover itself, so you need to arrange this using a middleware framework such as MySQL Router 8.0, a proxy, a connector, or the application itself. In MySQL 8.0.14 and later, if you want to have a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-table-external.html
mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | +-------------------------+ For more information about file-per-table tablespaces, see Section 17.6.3.2, ... There are ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. Note In MySQL 8.0, it is possible to match against only a list of integers (and possibly NULL—see Section 26.2.7, “How MySQL Partitioning Handles NULL”) when ...As in ...
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/mysql-cluster-ndbinfo-threadstat.html
The values of the os_ru_utime, os_ru_stime, os_ru_minflt, os_ru_majflt, os_ru_nvcsw, and os_ru_nivcsw columns are obtained using the system getrusage() call, or the equivalent. Since this table contains counts taken at a given point in time, for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-starting.html
NoOfFragmentLogFiles=300 DataDir=path/to/data/node/data/directory MaxNoOfConcurrentOperations=100000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 # Setting these parameters allows you to take advantage of real-time ...