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. For MySQL 5.6.22 and supported later versions (including version 8):.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 For MySQL 5.6.20 and 5.6.21 (you can determine your MySQL version by using mysql -version) :.O Alternatively, you can disable binary logging: log_bin=0 For MySQL 8 you have to set the following variable:.If the parameters are not present in the file, add them to the section: If the file is not present, try /etc/my.cnf or /etc/my.cnf.d/community-mysql-server.cnfĢ.Find the following configuration in the section of the my.cnf file and modify the values. Manual installation – download and install MySQL Community Server edition from: ġ.Run the following command to openss the my.cnf ( my.ini for Windows installation) file in a text editor:.Sudo zypper install mysql-community-server
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |