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/innodb-and-mysql-replication.html
It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
The cache_policies table, config_options table, and containers table are created by the innodb_memcached_config.sql configuration script in the innodb_memcache database. The containers table contains a default entry for the test.demo_test table, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
CREATE VIEW numbers AS SELECT c1 KEY, CAST(c2 AS UNSIGNED INTEGER) val FROM demo_test WHERE c2 BETWEEN '0' and '9999999999'; SELECT SUM(val) FROM numbers; Note Any alphabetic values in the result set are converted into 0 by the call to CAST().
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
The procedure assumes that you only have .ibd file backups, you are recovering to the same version of MySQL that initially created the orphan .ibd files, and that .ibd file backups are clean. See Section 17.6.1.4, “Moving or Copying InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to indexes other than primary keys (either explicit or implicit). ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html
In the case where it is string, the function returns the amount of storage space in the JSON binary representation that is created by parsing the string as JSON and converting it to binary. This section documents utility functions that act on JSON ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-component.html
The database administrator has the responsibility for creating any configuration files to be used, and for ensuring that their contents are correct. Given the preceding configuration file properties, to configure component_keyring_encrypted_file, ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
The database administrator has the responsibility for creating any configuration files to be used, and for ensuring that their contents are correct. Given the preceding configuration file properties, to configure component_keyring_file, create a ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
The namespace enables different applications to use the same lock names without colliding by creating locks in separate namespaces. MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
myisam_max_sort_file_size The maximum size of the temporary file that MySQL is permitted to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA). If the file size would be larger than this value, the index is created ... The following options to mysqld can be used to change the behavior of MyISAM ...