Solved

set new default value for max_heap_table_size

Posted on 2012-04-08
7
855 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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Compiling PHP with Curl plus protocols 8 44
sort Multi-dimensional array 6 40
Why is my implode function empty 8 38
XML loaded in a form with dropdown 6 47
Creating and Managing Databases with phpMyAdmin in cPanel.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

738 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