Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The tradeoffs are: An index must be updated when table data is modified. The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The ...The table ...This is needed when reading and parsing histograms from persistent storage into ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
The directory specified in a DATA DIRECTORY clause must be known to InnoDB. However, this is dependent on the operating system, and may not be possible or advisable on all platforms; see Section B.3.2.16, “File Not Found and Similar Errors”, for ...However, the result must be an integer value or NULL (except in the case of [LINEAR] KEY partitioning, as discussed elsewhere in this chapter; see Section 26.2, “Partitioning Types”, for more ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
There could be inconsistencies in both InnoDB and non-InnoDB data if any changes are made while those files are being backed up. Warning This option can cause an incomplete or inconsistent backup if, during the backup operation, DDL operations are ...--sleep=MS Command-Line Format --sleep=MS Type Numeric Default Value 0 Unit millisecond Specify the number in milliseconds to sleep after copying a certain amount of data from InnoDB ... These ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-mysql-instances-permissions.html
Administer is also required by the Database File I/O, which requires the sys schema. MySQL Instances: grants access to the data collected on the monitored MySQL Instances. Possible values are: None: No access to MySQL Instances or the data collected ...That is, if Server Group is set to Read-Only, or higher, MySQL Instances must be set to Read-Only at ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
MySQL HeatWave GenAI supports OCR in the following unstructured data formats: PDF (including scanned PDF files), DOC, DOCX, PPT, and PPTX. It automatically parses unstructured data formats, which include PDF (including scanned PDF files), PPT, TXT, ... This section describes the Vector Store functionality available in MySQL ...About Optical Character Recognition Optical Character Recognition (OCR) in MySQL HeatWave ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
However, InnoDB provides a start up option called innodb-status-file, which dumps the same output as SHOW ENGINE INNODB STATUS to a file called innodb_status.mysql pid in the datadir. Default frequency 12:00:00 Default auto-close enabled yes InnoDB ...Default frequency 00:05:00 Default auto-close enabled no InnoDB Strict Mode Is Off To guard against ignored typos and syntax errors in SQL, or other unintended consequences of various combinations of operational modes and SQL commands, InnoDB provides a strict mode of ...
https://dev.mysql.com/doc/workbench/en/wb-view-editor.html
To invoke the view editor, double-click a view object on the EER Diagram canvas or double-click a view in the Physical Schemas section on the MySQL Model page. This opens the view editor docked at the bottom of the application. Any number of views ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
The following must be true for the password file: The file must be present on each host where mcmd runs a data node that is being restored. Stop the cluster using stop cluster, then restart it using start cluster with the --initial option, which ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-ddlstatementactivity-category.html
Table 6.5 DDL Statement Activity Metrics NameDescriptionAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter DB Upgrade (Delta) The total number of ALTER DATABASE ... Create DB (Delta) The total number of CREATE DATABASE ...