Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
This histogram type is created when the number of distinct values in the column is less than or equal to the number of buckets specified in the ANALYZE TABLE statement that generated the histogram. This histogram type is created when the number of ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. In MySQL terminology, a "key" is something that you create with CREATE [UNIQUE] INDEX. You can verify that by executing the same statements and looking at a hexadecimal dump yourself. The ...
https://dev.mysql.com/doc/refman/8.4/en/bug-reports.html
If you get a parse error for an SQL statement, please check your syntax closely. If you are using the current version and the manual doesn't cover the syntax that you are using, MySQL Server doesn't support your statement. If your report includes ...
https://dev.mysql.com/doc/refman/8.4/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished using the ALTER TABLE statement with the DROP PARTITION option. If you wish to drop all data from all partitions while preserving the table ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
To perform the same check with GTID_SUBTRACT(), execute the following statement on the replica: SELECT GTID_SUBTRACT(source_gtid_executed, replica_gtid_executed); This statement returns any GTIDs that are in source_gtid_executed but not in ... This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not start.
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the statement. For TEMPTABLE, the results from the view are retrieved into a ... The ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-32.html
(Bug #108814, Bug #34717205) When Connector/J looked for the presence of the ON DUPLICATE KEY UPDATE clause in prepared statements, it neglected the cases where the VALUES function was used without the VALUE(S) clause in INSERT statements. As a ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
The execution of the query is modified to use an index previously defined. There must be an index defined on the columns mapped to the ordering fields, in the order of the ordering fields. There must be no gaps in the ordering fields relative to the ... A Query instance represents a specific query with bound ...