Search Results
https://dev.mysql.com/doc/workbench/en/wb-audit-inspector.html
To activate the audit_log plugin manually using mysql, load the plugin code from the library file at runtime with the INSTALL PLUGIN statement. Each record includes a record ID, timestamp, type, connection ID, user, host/IP, status, command class, ... MySQL Workbench offers a graphical interface to MySQL Enterprise ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
Partitioning table data by JOIN and GROUP BY key columns can improve query performance by avoiding costs associated with redistributing data among MySQL HeatWave nodes at query execution time. A query executed on a table that is no longer loaded or ...Data placement keys are used to partition table data among MySQL HeatWave nodes when loading ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. An ...It ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
Create the database first; its name should not exceed 64 characters. On each replica node, extract the INSTALL PLUGIN statement from the installation script and execute it manually. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ... This ...
https://dev.mysql.com/doc/internals/en/variation-of-protocol-option.html
If not, do something of the following: Exclude some protocol variants from execution. It is usual to run tests with and without the mysql-test-run.pl startup option "--ps-protocol". And there are also attempts of System QA to run the other ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
If you kill myisampack, the .TMD file might not be deleted.) Normally, myisampack exits with an error if it finds that tbl_name.TMD exists. When the table is used later, the server reads into memory the information needed to decompress columns. This ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
You want to use a column containing date or time values, or containing values arising from some other series. For example, when executing a query such as EXPLAIN SELECT COUNT(*) FROM employees WHERE separated BETWEEN '2000-01-01' AND '2000-12-31' ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
This ensures that the data node can run in a stable manner without using swap memory, so that NDB can be used for latency-sensitive (realtime) applications. The reserved memory area can be used only by the resource for which it is reserved and ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-introduction.html
The size of the buffer that is allocated initially (16KB) is automatically increased up to the maximum size (16MB by default). Because buffer sizes are increased only as demand warrants, simply increasing the maximum limit does not in itself cause ... The C API provides low-level access to the MySQL client/server protocol and enables C programs to access database ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-12-1-0-4-0.html
The thresholds of the following metrics have been changed from critical to warning, and from warning to info: Table Cache Not Optimal Thread Cache Size Not Optimal Bugs Fixed Path-related errors occurred when using Oracle Enterprise Manager for ...