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-best-practices.html
Foreign keys also propagate deletes and updates to all affected tables, and prevent insertion of data in a child table if the corresponding IDs are not present in the parent table. While you don't want to commit too often, you also don't want to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-dml.html
Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and deletes) more than it speeds up queries. INSERT becomes add, UPDATE becomes set, incr or decr, and DELETE becomes delete. Therefore, consider ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
Reducing Transactional Overhead A default value of 1 for daemon_memcached_r_batch_size and daemon_memcached_w_batch_size is intended for maximum reliability of results and safety of stored or updated data. Benchmarks suggest that queries and DML ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
During startup, discovered tablespace files are used instead those referenced in the data dictionary, and the data dictionary is updated to reference the relocated files. For example, after relocating the data directory, you must update the ... The ...
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 ...