PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgmd.html
--config-cache Command-Line Format --config-cache[=TRUE|FALSE] Type Boolean Default Value TRUE This option, whose default value is 1 (or TRUE, or ON), can be used to disable the management server's configuration cache, so that it reads its ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
This is equal to the number of data nodes in the cluster at the time that the backup was created. --connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. The Performance Schema tables provide a container to ... The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/upgrading-what-is-upgraded.html
One way that FORCE differs from AUTO is that with FORCE, the server re-creates system tables such as help tables or time zone tables if they are missing. With respect to the content of the help tables and time zone tables, mysql_upgrade does not ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
The position is given as a timestamp and the read starts from the first event that occurs on or after the timestamp value. The start item has this format, where value is a literal timestamp value: "start": { "timestamp": "value" } The start item is ...Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] 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 | ...
https://dev.mysql.com/doc/refman/8.0/en/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 ...