set new default value for max_heap_table_size
Posted on 2012-04-08
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 :)