?
Solved

set new default value for max_heap_table_size

Posted on 2012-04-08
7
Medium Priority
?
869 Views
Last Modified: 2012-04-09
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 :)
0
Comment
Question by:Puzatiy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37821591
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
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37821600
Modify the contents of the /etc/my.cnf file under the [mysqld] section.

max_heap_table_size=524288000


http://web3us.com/drupal6/how-create-web-site-handbook/how-setup-mysql/tuning-mysql
0
 
LVL 3

Author Comment

by:Puzatiy
ID: 37821826
but im running the server in wamp server for windows...
so is there any file that simular to the my.cnf file.. thanks ahead
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 24

Expert Comment

by:johanntagle
ID: 37822009
I don't know where it is actually located as I don't use windows but look for a my.ini file
0
 
LVL 3

Author Comment

by:Puzatiy
ID: 37823359
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..
0
 
LVL 24

Accepted Solution

by:
johanntagle earned 2000 total points
ID: 37825402
As anuroopsundd said, just add the line under the [mysqld] section.
0
 
LVL 24

Expert Comment

by:johanntagle
ID: 37826019
Thanks but you should have given most of the points to anuroopsundd
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question