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/partitioning-types.html
However, it is not difficult in MySQL to create partitioning schemes based on DATE, TIME, or DATETIME columns, or based on expressions making use of such columns. This section discusses the types of partitioning which are available in MySQL 8.0.
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
Beginning with MySQL 8.0.20, you can enable binary log transaction compression on a MySQL server instance. Compressed transaction payloads remain in a compressed state while they are sent in the replication stream to replicas, other Group ...When ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
To set the relevant variables at server startup, put these lines in the server my.cnf file: [mysqld] plugin-load-add=connection_control.so connection-control-failed-connections-threshold=4 connection-control-min-connection-delay=2000 To set and ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.0. For guidance regarding buffer pool size configuration, see Section 10.12.3.1, “How MySQL Uses Memory”. Thus, take care to avoid transactions ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication.html
This chapter explains MySQL Group Replication and how to install, configure and monitor groups. MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies. Groups can operate in a single-primary ...Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
Source files that use the locking service should include this header file: #include <mysql/service_locking.h> To acquire one or more locks, call this function: int mysql_acquire_locking_service_locks(MYSQL_THD opaque_thd, const char* lock_namespace, ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. From MySQL 8.0, this repository is created by default as an ...
https://dev.mysql.com/doc/refman/8.0/en/command-line-options.html
The MySQL server has certain command options that may be specified only at startup, and a set of system variables, some of which may be set at startup, at runtime, or both. For example, the following command tells mysqladmin to ping the server 1024 ...For example, -? and --help are the short and long forms of the option that instructs a MySQL program to display its help ...
https://dev.mysql.com/doc/refman/8.0/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. MySQL provides ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
FOR SHARE statements do not acquire read locks on MySQL grant tables. Here, FOR SHARE is not a good solution because if two users read the counter at the same time, at least one of them ends up in deadlock when it attempts to update the counter. In ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough ...