Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/myisam-start.html
bulk_insert_buffer_size The size of the tree cache used in bulk insert optimization. The following options to mysqld can be used to change the behavior of MyISAM tables. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers ...
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-repair-options.html
An option value of 0 disables updates to all indexes, which can be used to get faster inserts. --correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. --data-file-length=len, -D len Command-Line ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-batch-commands.html
For this you can insert statements like this: SELECT '<info_to_display>' AS ' '; The statement shown outputs <info_to_display>. The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-disk-data-objects.html
Once table ts_1 has been created as shown, you can perform INSERT, SELECT, UPDATE, and DELETE statements on it just as you would with any other MySQL table. NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-syntax.html
This is because an update of a primary key is implemented as a delete of the old row (containing the old primary key) plus an insert of the new row (with a new primary key). Some SQL statements relating to certain MySQL features produce errors when ...