Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise-backup.html
The product is architected for efficient and reliable backups of tables created by the InnoDB storage engine. For completeness, it can also back up tables from MyISAM and other storage engines. MySQL Enterprise Backup does a hot backup of all tables ... MySQL Enterprise Backup performs hot backup operations for MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/nested-loop-joins.html
MySQL executes joins between tables using a nested-loop algorithm or variations on it. Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, passing ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
The GROUP BY and ORDER BY clauses can generate temporary tables, and these temporary tables can use the MEMORY storage engine if the original table does not contain any BLOB columns. If a table contains string columns such as name and address, but ... For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
Increase buffer pool size When table data is cached in the InnoDB buffer pool, it can be accessed repeatedly by queries without requiring any disk I/O. Do not place other MySQL data files, such as those for MyISAM tables, on a direct I/O file system. Executables or libraries must not be placed on a direct I/O file ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
See Section 15.1.20, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-timing.html
For example, the standard gettimeofday() function can take hundreds of cycles, which is an unacceptable overhead for data gathering that may occur thousands or millions of times per second. Performance Schema Timer Representation in Events Rows in ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-examples.html
Consider these statements: mysql> CREATE TABLE t (i INT, d DECIMAL, f FLOAT); mysql> INSERT INTO t VALUES(1,1,1); mysql> CREATE TABLE y SELECT AVG(i), AVG(d), AVG(f) FROM t; The result is a double only for the floating-point argument. This section ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-reserved-words.html
For example, a table column named rank on a MySQL 5.7 source that is replicating to a MySQL 8.4 replica could cause a problem because RANK became a reserved word in MySQL 8.0. Replication can fail in such cases with Error 1064 You have an error in ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
You can list the events on a server using the SHOW statement or the Information Schema EVENTS table. For example, the InnoDB system tablespace, undo tablespace, and redo log might be stored in an alternative location. InnoDB tablespace files and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-partitioning.html
Figure 19.2 Replicating Databases to Separate Replicas You can achieve this separation by configuring the source and replicas as normal, and then limiting the binary log statements that each replica processes by using the --replicate-wild-do-table ... There may be situations where you have a single source server and want to replicate different databases to different ...