Search Results
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/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/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/8.4/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/8.4/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/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
In other words, when performing on the source a series of statements (INSERT, DELETE, or both) that changes the number of rows in a table within a single transaction, executing SELECT COUNT(*) FROM table queries on the replica may yield intermediate ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-logs-event-buffer.html
These events consist of operation types (insert, update, delete) and row data (before and after images plus metadata). NDB uses one or more memory buffers for events received from the data nodes. There is one such buffer for each Ndb object ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mysqld.html
Insert a line containing ndbcluster in the [mysqld] section of your my.cnf file. To be used with NDB Cluster, mysqld needs to be built with support for the NDB storage engine, as it is in the precompiled binaries available from ...