Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
The insert buffer merge and the purge are performed during normal processing. To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. Recovery from Data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log-buffer.html
Thus, if you have transactions that update, insert, or delete many rows, increasing the size of the log buffer saves disk I/O. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer ...
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to register the component. [SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} ...
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the plugin. INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. plugin_name is the name ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
For example, an index continues to be updated per changes to table rows, and a unique index prevents insertion of duplicates into a column, regardless of whether the index is visible or invisible. MySQL supports invisible indexes; that is, indexes ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) Extracts data from a JSON document and returns it as a relational table having the specified ...
https://dev.mysql.com/doc/refman/8.4/en/key-space.html
This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. If the first index part is a ...
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/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. MySQL sometimes optimizes a query that has a LIMIT row_count clause and no ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
User variables can be especially useful when you want to insert data from an XML file into table columns whose names do not match those of the XML fields. The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, ...