Solved

set new default value for max_heap_table_size

Posted on 2012-04-08
7
841 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
  • 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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 500 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

The purpose of this article is to demonstrate how we can use conditional statements using Python.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…

786 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