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/federated-create-connection.html
The connection string specifies the server name, login credentials, port number and database/table information. To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). Before querying it, set the value of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). Before querying it, set the value of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
Data is stored in a MySQL database to protect against crashes, outages, and corruption. The direct, low-level database access path used by the daemon_memcached plugin is much more efficient for key-value lookups than equivalent SQL queries. The ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. The ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-ftdump.html
If you do not invoke myisam_ftdump in the directory where the table files are located, the table or index file name must be preceded by the path name to the table's database directory. Example: Suppose that the test database contains a table named ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-resolved.html
These are described briefly in the following list: Database and table names. In NDB 7.6 and earlier, when using the NDB storage engine, the maximum allowed length both for database names and for table names was 63 bytes, and a statement using a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
MaxNoOfAttributes: Suggests total number of attributes stored in database (sum over all tables). TimeBetweenLocalCheckpoints: Time between taking snapshots of database (expressed in base-2 logarithm of bytes). The listings in this section provide ...
25.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.