Search Results
https://dev.mysql.com/doc/refman/9.7/en/pluggable-storage-common-layer.html
Performance Aids: This includes multiple I/O threads for parallel operations, thread concurrency, database checkpointing, bulk insert handling, and more. A MySQL pluggable storage engine is the component in the MySQL database server that is ...
https://dev.mysql.com/doc/refman/9.7/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/9.7/en/plugin-loading.html
For this reason, INSTALL PLUGIN requires the INSERT privilege for the mysql.plugin table. Server plugins must be loaded into the server before they can be used. It is also possible to control the activation state of loaded plugins at startup, and ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-decimal-characteristics.html
If you insert +0003.1 into a DECIMAL(5,1) column, it is stored as 3.1. This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format ...
https://dev.mysql.com/doc/refman/9.7/en/privilege-changes.html
If you modify the grant tables directly using statements such as INSERT, UPDATE, or DELETE (which is not recommended), the changes have no effect on privilege checking until you either tell the server to reload the tables or restart it. If the ...
https://dev.mysql.com/doc/refman/9.7/en/query-attributes.html
The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the next statement sent to the server for execution: Attributes are defined prior to sending the statement. Attributes ...
https://dev.mysql.com/doc/refman/9.7/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You can rename tables locked with a LOCK TABLES statement, ...
https://dev.mysql.com/doc/refman/9.7/en/repair-table.html
[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines only. Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data ...
https://dev.mysql.com/doc/refman/9.7/en/replica-logs-status.html
Important Do not attempt to update or insert rows in the mysql.slave_master_info or mysql.slave_relay_log_info tables manually. A replica server creates two replication metadata repositories, the connection metadata repository and the applier ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-blackhole.html
When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. The BLACKHOLE storage engine accepts data but discards it and does not store it. Updates and deletes are handled differently ...