Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Is it possible to group stored procedures or stored functions into packages? A.4.9. Is it possible to group stored procedures or stored functions into packages? No. Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
Can you insert into views that are based on joins? A.6.1. Can you insert into views that are based on joins? It is possible, provided that your INSERT statement has a column list that makes it clear there is only one table involved. You cannot ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
FLUSH TABLES WITH READ LOCK does not prevent the server from inserting rows into the log tables (see Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). The .cfg file contains metadata needed to reimport the ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
A value of 6 is considered drastic because database pages are left in an obsolete state, which in turn may introduce more corruption into B-trees and other database structures. Leaves database pages in an obsolete state, which in turn may introduce ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html
(This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column of the same type but having fewer fractional digits results in ... 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, DATETIME, or TIMESTAMP, and fsp is the fractional seconds ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. If you create a MyISAM table and insert only one or two rows of text into it, every word in the text occurs in at least 50% of the rows. By ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
In practical terms, the user may expect that once his application fails-over to the new primary, there would be no chance, even if temporarily, to read old data or write into old data records. No read skew on read/write transactions, such as this ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-limitations.html
Group Replication's certification process for concurrent transactions does not take into account gap locks, as information about gap locks is not available outside of InnoDB. The certification process does not take into account table locks (see ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
The majority of the time the system does not run into partitioning, and therefore the table shows information that is consistent across all servers in the group. This information is exported by the local failure detector built into Group Replication. You can verify this by logging into s1 and looking at its replication_group_members performance schema ...
https://dev.mysql.com/doc/refman/8.4/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.