All Solution List
Add New Solution
Pending Solution
Completed Solution
Checking Solution
All Cards Solution
Edit Solutions
Question
main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 295; Allocated memory size: 66198000 bytes; InnoDB buffer pool size: 134217728 bytes.
Assigner
Mukesh
Rashika
Atish
Aaditya
Kalyani
Brij
Developer
Mukesh
Rashika
Atish
Aaditya
Kalyani
Brij
Module
Product
Errors
Category
PHP
MYSQL
Status
Pending
Done
Checking
Working
Answer
https://serverfault.com/questions/659597/how-to-permanently-increase-innodb-buffer-pool-size-on-ubuntu Here's what worked for me (ubuntu 19, mysql 8): sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf add in this at the bottom of the file innodb_buffer_pool_size = 8G save and exit. restart MySQL. sudo systemctl restart mysql
SAVE