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/faqs-sql-modes.html
This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. Is the mode dependent on the database or connection? A mode is not linked to a particular database. What is the default server SQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
Specifically, replicated databases have to deal with the fact that they require maintenance and administration of several servers instead of just one. Therefore, the ultimate challenge is to fuse the logic of the database and data replication with ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. Beginning with MySQL 8.0.32, use of the dollar sign as the ...Section 11.2.1, “Identifier Length Limits”, indicates the maximum length of each type of ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. Note Comparison behavior for database and table names in INFORMATION_SCHEMA queries might differ from what you expect. This includes values such as database and ...To write queries for these tables most efficiently, use the following general guidelines: Try to query only INFORMATION_SCHEMA tables that are views on data dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-checkpoints.html
InnoDB flushes modified database pages from the buffer pool in small batches. It knows that all modifications to the database before the label are present in the disk image of the database. Then InnoDB scans the log files forward from the ... Making ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
The “non-strict” behavior lets you import a mysqldump file into a database that does not support compressed tables, even if the source database contained compressed tables. To import the dump file into a new database, and have the tables ...
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. mysql> USE innodb_memcache; Database changed mysql> SHOW TABLES; ... InnoDB API ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. Update undo logs are used also in consistent reads, but ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...
https://dev.mysql.com/doc/refman/8.0/en/introduction.html
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. The following list describes some sections of particular interest in this manual: For a discussion of MySQL Database ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This means that you must know ...