https://dev.mysql.com/resource-groups.html
Currently, CPU time is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. Some attributes are fixed at creation time; others can be modified any ...
https://dev.mysql.com/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/audit-log-file-formats.html
<AUDIT_RECORD> <TIMESTAMP>2017-10-16T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2017-10-16T14:06:33</RECORD_ID> <NAME>Query</NAME> <CONNECTION_ID>5</CONNECTION_ID> <STATUS>0</STATUS> <STATUS_CODE>0</STATUS_CODE> <USER>root[root] @ localhost ... The MySQL ...
https://dev.mysql.com/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. The incremental backups are smaller and take less time to produce. The tradeoff is that, at recovery time, you cannot restore your data just by ...For ...
https://dev.mysql.com/create-trigger.html
CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } ...A ...
https://dev.mysql.com/events-stages-current-table.html
The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is the current timer value and TIMER_WAIT is the time elapsed so far (TIMER_END − TIMER_START). If an event is produced from ...The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...
https://dev.mysql.com/events-transactions-current-table.html
The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is the current timer value and TIMER_WAIT is the time elapsed so far (TIMER_END − TIMER_START). If an event is produced from ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/innodb-compression-tuning.html
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data. If the system performs DML operations on compressed tables, and the way the ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/mysql-cluster-replication-conflict-resolution.html
Some types of conflict resolution supported by NDB Cluster (NDB$OLD(), NDB$MAX(), NDB$MAX_DELETE_WIN()) implement this user-defined column as a “timestamp” column (although its type cannot be TIMESTAMP, as explained later in this section). On ...
https://dev.mysql.com/mysql-nutshell.html
Like the sha256_password plugin, caching_sha2_password implements SHA-256 password hashing, but uses caching to address latency issues at connect time. DBAs can require that new passwords not be selected from previous passwords for some number of ...
