set new default value for max_heap_table_size

hello experts,
i want to set new value to the max_heap_table_size variable.
i know how to do this, and i know how to set the global variable, but how can i set the default value.
so when the server start-up i want that the new value take place instead of the default value.

so assuming that mysql default value is 16M i want to change it to 32M..

how do i do it?? how do i change the DEFAULT value, not session or global, DEFAULT.
is there a file that i should edit?

thanks ahead :)
Konstantin KrolikovAsked:
Who is Participating?
johanntagleConnect With a Mentor Commented:
As anuroopsundd said, just add the line under the [mysqld] section.
to view max_heap_table_size
select @@max_heap_table_size;

And then you can run a query to set it higher:

set @@max_heap_table_size=NUMBER_OF_BYTES
Modify the contents of the /etc/my.cnf file under the [mysqld] section.

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Konstantin KrolikovAuthor Commented:
but im running the server in wamp server for windows...
so is there any file that simular to the my.cnf file.. thanks ahead
I don't know where it is actually located as I don't use windows but look for a my.ini file
Konstantin KrolikovAuthor Commented:
yes i know where this file is, however i have no idea what i should edit there.
i know there is a lot of variables there but no max_heap_table_size..
Thanks but you should have given most of the points to anuroopsundd
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.