PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.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/5.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/5.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/5.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/5.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/5.7/en/query-cache-thread-states.html
This can happen for any statement that needs to perform some query cache operation, such as an INSERT or DELETE that invalidates the query cache, a SELECT that looks for a cached entry, RESET QUERY CACHE, and so forth. These thread states are ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache.html
A query mix consisting almost entirely of a fixed set of SELECT statements is much more likely to benefit from enabling the cache than a mix in which frequent INSERT statements cause continual invalidation of results in the cache. Note The query ...
https://dev.mysql.com/doc/refman/5.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] ... To execute RENAME TABLE, there must be no active ...
https://dev.mysql.com/doc/refman/5.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/5.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 ...