![]() ![]() O innodb_log_file_size needs to be set to at least 200 MB (for example, innodb_log_file_size=200M), but not more than 3000 MB.Ĥ.Open the Command Prompt and enter the following commands to restart the MySQL server and apply the configuration (the process name depends on the MySQL version: 8.0 = mysql80 etc.):ĥ.Table of Contents Preface and Legal Notices 1 Installing and Upgrading MySQL 2 General Installation Guidance 2.1 Supported Platforms 2.2 Which MySQL Version and Distribution to Install 2.3 How to Get MySQL 2.4 Verifying Package Integrity Using MD5 Checksums or GnuPG 2.4.1 Verifying the MD5 Checksum 2.4.2 Signature Checking Using GnuPG 2.4.3 Signature Checking Using Gpg4win for Windows 2.4.4 Signature Checking Using RPM 2.4.5 GPG Public Build Key for Archived Packages 2.5 Installation Layouts 2.6 Compiler-Specific Build Characteristics 3 Installing MySQL on Unix/Linux Using Generic Binaries 4 Installing MySQL from Source 4.1 Source Installation Methods 4.2 Source Installation Prerequisites 4.3 MySQL Layout for Source Installation 4.4 Installing MySQL Using a Standard Source Distribution 4.5 Installing MySQL Using a Development Source Tree 4.6 Configuring SSL Library Support 4.7 MySQL Source-Configuration Options 4.8 Dealing with Problems Compiling MySQL 4.9 MySQL Configuration and Third-Party Tools 5 Installing MySQL on Microsoft Windows 5.1 MySQL Installation Layout on Microsoft Windows 5.2 Choosing an Installation Package 5.3 MySQL Installer for Windows 5.3.1 MySQL Installer Initial Setup 5.3.2 Setting Alternative Server Paths with MySQL Installer 5.3.3 Installation Workflows with MySQL Installer 5.3.4 MySQL Installer Product Catalog and Dashboard 5.3.5 MySQL Installer Console Reference 5.4 Installing MySQL on Microsoft Windows Using a The minimum value for innodb_log_files_in_group is 2 and maximum value is 100, the value also has to be integer). O innodb_log_file_size*innodb_log_files_in_group needs to be set to at least 200 MB (* denotes multiplication, the product of the two parameters must be > 200 MB. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |