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/fractional-seconds.html
MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...A ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The chief difference between the two types of partitioning is that, in list partitioning, each ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
A parameter which is an operand of a temporal operator has type DATETIME if the operator returns a DATETIME, TIME if the operator returns a TIME, and DATE if the operator returns a DATE. Exceptions: The derived type is TIME and the actual type is ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
How do I know how late a replica is compared to the source? In other words, how do I know the date of the last statement replicated by the replica? A.14.4. How do I force the source to block updates until the replica catches up? A.14.5. The replica ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Read-only transactions could result in outdated values, read/write transactions could result in a rollback due to conflicts. Scenario 3: You want specific transactions to read only up-to-date data from the group, so that whenever sensitive data such ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
The replication group must therefore be restarted beginning with the most up to date member, that is, the member that has the most transactions executed and certified. It is not correct to assume that the last known primary member of the group is ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
If data is synchronized at the time of a read, the current client session waits until a given point, which is the point in time that all preceding update transactions have been applied, before it can start executing. For a group that has ... In ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
If up-to-date statistics are required immediately, run ANALYZE TABLE to initiate a synchronous (foreground) recalculation of statistics. row *************************** database_name: sakila table_name: actor last_update: 2014-05-28 16:16:44 n_rows: ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...