Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-midpoint_insertion.html
Both innodb_old_blocks_pct and innodb_old_blocks_time can be specified in the MySQL option file (my.cnf or my.ini) or changed at runtime with the SET GLOBAL statement. Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-multiple_io_threads.html
You can set values for these parameters in the MySQL option file (my.cnf or my.ini); you cannot change values dynamically. InnoDB uses background threads to service various types of I/O requests. You can configure the number of background threads ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
Copy the my.cnf or my.ini option file used by the existing instance. Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a data directory for a new instance: Create a new data directory.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
(For example, 100K means 100 × 1024 = 102400.) Parameter names and values are case-insensitive, unless used in a MySQL Server my.cnf or my.ini file, in which case they are case-sensitive. The [ndbd] and [ndbd default] sections are used to ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning.html
Nothing further needs to be done to enable partitioning support by InnoDB (for example, no special entries are required in the my.cnf file). Note Table partitioning differs from partitioning as used by window functions. In MySQL 8.4, partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
To set the SQL mode at server startup, use the --sql-mode="modes" option on the command line, or sql-mode="modes" in an option file such as my.cnf (Unix operating systems) or my.ini (Windows). The MySQL server can operate in different SQL modes, ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A MySQL server installed as a service can also be controlled from the command line using ...
https://dev.mysql.com/doc/mysqld-version-reference/en/options-variables.html
The following table shows all the options and variables available in MySQL Server. Intr: The version or versions in which the item was introduced. Depr: The version or versions in which the item was deprecated. Removed: The version or versions in ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
Unless those objects are installed, the audit_log plugin operates in (deprecated) legacy mode. Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be ...