Search Results
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-show-status.html
The Status column contains a description of the cluster's status; possible values and their meanings are shown in the following table: Table 5.1 Status values shown by show status --cluster Status Value Meaning fully operational All cluster ... show ...
https://dev.mysql.com/doc/relnotes/mysql-ai/en/news-9-5-0.html
This feature collects information on the schemas, tables, and columns that you have access to, and then uses a Large Language Model (LLM) to generate an SQL query for the question pertaining to your data. (Bug #38193173, WL #16315) MySQL AI now lets ... AutoML GenAI InnoDB Notes Security Notes AutoML MySQL AI AutoML now supports advanced recommendation capabilities with the introduction of Deep Recommendation models, a deep learning-based approach to building embedding models for personalized ...
https://dev.mysql.com/doc/refman/9.7/en/charset-database.html
Database options are stored in the data dictionary and can be examined by checking the Information Schema SCHEMATA table. To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/9.7/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Then you can answer different sorts of questions about your animals by retrieving data from the tables. Once you know how to enter SQL statements, you ...
https://dev.mysql.com/doc/refman/9.7/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes ...
https://dev.mysql.com/doc/refman/9.7/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. To keep this from happening, ensure that all tables in the database use a storage engine that supports atomic DDL (see Section ...
https://dev.mysql.com/doc/refman/9.7/en/environment-variables.html
This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual. Options on the command line take precedence over values specified in option files and ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-information-schema.html
Can I add to or otherwise modify the tables found in the INFORMATION_SCHEMA database? A.7.1. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? See Chapter 28, INFORMATION_SCHEMA Tables. What is the difference between the ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-tablespace-encryption.html
Does the transportable tablespaces feature work with InnoDB data-at-rest encryption? A.17.12. How do I migrate data from a cleartext InnoDB tablespace to an encrypted InnoDB tablespace? A.17.1. It uses Electronic Codebook (ECB) block encryption mode ...Is data decrypted for users who are authorized to see it? ...
https://dev.mysql.com/doc/refman/9.7/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...Depending on how the data is distributed, the queries might perform less I/O and take up less cache memory because the relevant columns are packed together on ...