Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimize-blob.html
When storing a large blob containing textual data, consider compressing it first. For example, to retrieve a BLOB might require a large sequential disk read that is better suited to a traditional hard drive than to an SSD device. Do not use this ...
https://dev.mysql.com/doc/refman/8.4/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 digits) ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
Dropping and re-creating the index is necessary and might take some time if the system has a large number of users and privileges. Check and repair operations can be time-consuming, particularly for large tables. Installing a new version of MySQL ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-faq.html
A.2: What is the big ibdata file that is in all the backups? You might find your backup data taking more space than expected because of a large file with a name such as ibdata1. This file represents the InnoDB system tablespace, which grows but ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-overview.html
Using GenAI, you can perform natural-language searches in a single step using either in-database or external large language models (LLMs). Key Features In-Database LLM GenAI uses a large language model (LLM) to enable natural language communication ... The GenAI feature of MySQL AI lets you communicate with unstructured data using natural-language ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-generate.html
The ML_GENERATE routine uses the specified large language model (LLM) to generate text-based content as a response for the given natural-language query. It can include the following parameters: task: specifies the task expected from the LLM.
https://dev.mysql.com/doc/refman/8.4/en/json.html
It is important to keep in mind that the size of any JSON document stored in a JSON column is limited to the value of the max_allowed_packet system variable. The value being replaced must be at least as large as the replacement value. In other ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
The dynamic file format is necessary if rows can vary in size. Page Size Unlike most DBMSs, MySQL doesn't store on disk using pages. Record Header The minimal record header is a set of flags: "X bit" = 0 if row is deleted, = 1 if row is not deleted ...MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Setting max_join_size to 1,000,000 causes multiple-table SELECT statements to produce an error if the server estimates it must examine more than 1,000,000 row combinations. For example, the left-arrow and right-arrow keys move horizontally within ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-transporters.html
Notes For each running data node in the cluster, the transporters table displays a row showing the status of each of that node's connections with all nodes in the cluster, including itself. Rows where the node_id is that of a data node which is not ...This information is shown in the table's status column, which can have any one of the following values: CONNECTING, CONNECTED, DISCONNECTING, or ...