To increase the mysql heap size
1. One way is we can start the mysql with necessary size
bin/mysqld_safe --user=mysql --max_heap_table_size=300000000 &
2. Another way is editing the my.cnf file
Open the file (/etc/mycnf)
Add a variable name and assign the relevant value for heap size
-> max_heap_table_size=300M
Restart the mysql
No comments:
Post a Comment