PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/explain.html
(See Section 15.2.13, “SELECT Statement”.) The optimizer trace may sometimes provide information complementary to that of EXPLAIN. (When there are multiple loops, this figure shows the average time per loop.) Number of rows returned by the ...In ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-replication.html
Must the replica be connected to the source all the time? A.14.2. Must the replica be connected to the source all the time? No, it does not. For example, you can set up a source/replica relationship over a dial-up link where the link is up only ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-resource-manager-component.html
The Group Replication Resource Manager component monitors secondary server lag time and memory usage, and can expel servers which lag excessively or use too many resources from the group. Allowable lag time and resource usage are configurable for ...URN: file://component_group_replication_resource_manager Prior to installing the Group Replication Resource Manager component, the Group Replication plugin should be installed using INSTALL PLUGIN or --plugin-load-add (see Section 20.2.1.2, “Configuring an Instance for Group ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/pluggable-authentication-system-variables.html
If the LDAP server does not respond to TCP handshake after a configured amount of time, MySQL abandons the TCP handshake attempt and emits an error message. If the timeout setting is zero, MySQL server ignores this system variable setting. Note If ...The file name should be given as an absolute path ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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 ...