PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
Adding a primary key using ALGORITHM=INPLACE is only permitted when the SQL_MODE setting includes the strict_trans_tables or strict_all_tables flags; when the SQL_MODE setting is strict, ALGORITHM=INPLACE is permitted, but the statement can still ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
After restarting a busy server, there is typically a warmup period with steadily increasing throughput, as disk pages that were in the buffer pool are brought back into memory (as the same data is queried, updated, and so on). Because data is cached ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
Modifications that did not finish updating data files before an unexpected shutdown are replayed automatically during initialization and before connections are accepted. On Unix and Unix-like operating systems, the performance impact is typically ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
To update invisible columns for UPDATE statements, name them and assign a value, just as for visible columns. An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html
Updating MySQL with Yum Besides installation, you can also perform updates for MySQL products and components using the MySQL Yum repository. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-alter-table-performance-schema.html
When the stage is completed, WORK_ESTIMATED is updated to the actual number of pages in the primary key. stage/innodb/alter table (flush): Before this stage begins, WORK_ESTIMATED is updated with a more accurate estimate, based on the length of the ... You can monitor ALTER TABLE progress for InnoDB tables using Performance ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
Use this for tables that are heavily used for searches but that are not updated. An update operation most frequently executed for temporary tables is performed much faster when the updated node is in the cache and need not be read from disk first.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Since NDB does not use single-key access for ordered indexes, the counts for tot_key_reads, tot_key_inserts, tot_key_updates, tot_key_writes, and tot_key_deletes are not incremented by ordered index operations. Note When using tot_key_writes, you ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam-bulk-data-loading.html
This does not update any indexes and therefore is very fast. This creates the index tree in memory before writing it to disk, which is much faster than updating the index during LOAD DATA because it avoids lots of disk seeks. INSERT, UPDATE, and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering-names.html
Names given for filtering operations can be as specific or general as required. For example, to select all file I/O instruments, it is better to use a pattern that includes the entire instrument name prefix: ... WHERE NAME LIKE 'wait/io/file/%'; A ...