https://dev.mysql.com/innodb-redo-log.html
With group commit, InnoDB issues a single write to the log file to perform the commit action for multiple user transactions that commit at about the same time, significantly improving throughput. Backup utilities that copy redo log records may ...
https://dev.mysql.com/innodb-restrictions-limitations.html
InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers of rows at the same time. This section describes restrictions and limitations of the InnoDB storage engine. You cannot ...
https://dev.mysql.com/innodb-session-temp-tablespaces-table.html
Session temporary tablespaces are recreated each time the server is started. The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The ...
https://dev.mysql.com/innodb-system-tablespace.html
For example, this tablespace has one auto-extending data file: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:10M:autoextend Suppose that the data file has grown to 988MB over time. The system tablespace is the storage area for the ...
https://dev.mysql.com/innodb-table-import.html
Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned ...
https://dev.mysql.com/innodb-transaction-scheduling.html
lock_schedule_refreshes The number of times the wait-for graph was analyzed to update the scheduled transaction weights. InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks.
https://dev.mysql.com/install-plugin.html
This means that a plugin is installed with INSTALL PLUGIN only once, not every time the server starts. INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. plugin_name is the name of the plugin as defined ...
https://dev.mysql.com/installing-development-tree.html
The initial download will take some time to complete, depending on the speed of your connection. This section describes how to install MySQL from the latest development source code, which is hosted on GitHub. To obtain the MySQL Server source code ...
https://dev.mysql.com/installing-source-distribution.html
Each time you run CMake, you must run make again to recompile. To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.9.2, “Source Installation Prerequisites”. Obtain a ...
https://dev.mysql.com/installing.html
If you plan to upgrade an existing version of MySQL to a newer version rather than install MySQL for the first time, see Section 2.11, “Upgrading MySQL”, for information about upgrade procedures and about issues that you should consider before ...A summary of the procedure follows and later sections provide the ...
