Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
When a new table row is inserted, the statement that produced the row digest value is stored as the current sample statement associated with the digest. The Performance Schema automatically sizes the values of several of its parameters at server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or deleted. The name of the performance_schema database is lowercase, as are the names of tables within it. Many ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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 ...