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/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is a set of one or more columns included in a FULLTEXT index. For each row in the ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
The key to safe database management is making regular backups. Note InnoDB does not support databases that are restored using third-party backup tools. Hot Backups The mysqlbackup command, part of the MySQL Enterprise Backup component, lets you ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Database Compression versus Application Compression Decide whether to compress data in your application or in the table; do not use both types of compression for the same data. Compressing in the Database When enabled, MySQL table compression is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
Example 19.2 Backup and restore scenario The stored functions GTID_IS_EQUAL(), GTID_IS_DISJOINT(), and GTID_IS_DISJOINT_UNION() can be used to verify backup and restore operations involving multiple databases and servers. In this example scenario, ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
In a multi-source replication topology, cloning or copying of the data directory cannot be used to provision the replica with data from all of the sources, and you might also want to replicate only specific databases from each source. If the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
Choose one of the following: If you do not have a snapshot of a database to import, see Section 19.1.2.6.1, “Setting Up Replication with New Source and Replicas”. If you have a snapshot of a database to import, see Section 19.1.2.6.2, “Setting ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational purposes. Previously, these tables were created in individual tablespace files in the ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.0/en/testing-server.html
Use mysqlshow to see what databases exist: $> bin/mysqlshow +--------------------+ | Databases | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ The list of installed databases may vary, ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...