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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
For example: mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'NO' WHERE NAME = 'wait/synch/mutex/sql/LOCK_mysql_create_db'; The Performance Schema uses collected events to update tables in the performance_schema database, which act ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE.
https://dev.mysql.com/doc/refman/8.0/en/replication-bugs.html
For example, if you update the replica outside of the replication threads, the data goes out of synchrony, and you can have unique key violations on updates. Ensure that the replica is running with binary logging enabled (the log_bin system ... When ...