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/innodb-online-ddl-single-multi.html
Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several changes to the same table at once, since those changes could all be done with a single rebuild operation for the table. The downside ... Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-key-cache.html
When blocks need to be replaced, blocks at the beginning of the list are the least recently used and become the first candidates for eviction. Then it discusses features that improve key cache performance and that enable you to better control cache ... To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
In this case, when the server opens a MyISAM table, it checks whether the table is marked as crashed or whether the open count variable for the table is not 0 and you are running the server with external locking disabled. If the server finds an ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--keys-used=val, -k val Command-Line Format --keys-used=val Type Numeric For myisamchk, the option value is a bit value that indicates which indexes to update. --safe-recover, -o Command-Line Format --safe-recover Do a repair using an old recovery ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. Benchmarks are typically long-running ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html
If you need to set any validate_password.xxx system variables, you can do so at runtime using SET GLOBAL. Note In MySQL 8.0, the validate_password plugin was reimplemented as the validate_password component. The validate_password plugin is ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. The user_summary and x$user_summary views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table ...file_ios The total number of file I/O events for the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-waits-by-host-by-latency.html
These views summarize wait events, grouped by host and event. By default, rows are sorted by host and descending total latency. The waits_by_host_by_latency and x$waits_by_host_by_latency views have these columns: host The host from which the ...