The minimal value for innodb_log_files_in_group is 2 and maximum value is 100, the value also has to be integer).ģ.Save and close the file and enter the following command to restart the MySQL server and apply the configuration (in some cases, the service name is mysqld):Ĥ.Run the following command to set up MySQL including privileges and password (this is optional and may not work for some Linux distributions):ĥ. 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):.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |