Search Results
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-maintenance.html
This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). For general myisamchk background, see Section 6.6.4, “myisamchk — MyISAM Table-Maintenance ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching rows. The algorithm used to carry out this process uses one of the table's indexes to carry out the search ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. plugin_name must be the name of ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). Now pruning continues in such cases, but with a warning printed in the error log stating that ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. Compilation Notes Configuration Notes InnoDB Notes Installation Notes Functionality Added or Changed Bugs Fixed Compilation Notes macOS: It is now possible to ...