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/server-system-variables.html
mysqldump performs a full table scan, which means its queries can often exceed a long_query_time setting that is useful for regular queries. From MySQL 8.0.30, if you want to exclude most or all of mysqldump’s queries from the slow query log, you ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
Logical backup tools include the mysqldump program and the SELECT ... This section describes the characteristics of different types of backups. Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For example, both mysql and mysqldump enable you to change the client-side max_allowed_packet value. See Section 7.1.1, “Configuring the Server”, Section 6.5.1, “mysql — The MySQL Command-Line Client”, and Section 6.5.4, “mysqldump — A ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or mysqldump. The examples here use the mysql client program, but the principles apply to other clients such ...For information on establishing connections using URI-like connection strings or key-value pairs, for clients such as MySQL Shell, see Section 6.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
ALGORITHM=1 is shown when necessary in the output of SHOW CREATE TABLE using versioned comments in the same manner as mysqldump. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
You can also use the traditional functionality provided for this purpose in mysqldump and the MySQL server. See Section 6.5.4, “mysqldump — A Database Backup Program”, for more information. In the following section, we answer questions that ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with InnoDB data-at-rest encryption? A.17.4. Is it possible to use 3rd party encryption algorithms in place of the one provided by the InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
Use mysqldump to create a source data snapshot, and sync the snapshot to the replica server. source $> mysqldump --all-databases --lock-all-tables > dbdump.db replica $> mysql < dbdump.db On the source server, issue SHOW MASTER STATUS to obtain the ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-importing-data.html
This data is most often available in one or more of the following formats: An SQL dump file such as produced by mysqldump or mysqlpump. It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB Cluster, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-overview.html
You can also use the standard MySQL functionality provided for this purpose in mysqldump and the MySQL server. See Section 6.5.4, “mysqldump — A Database Backup Program”, for more information. NDB Cluster is a technology that enables ...