Solved

set new default value for max_heap_table_size

Posted on 2012-04-08
7
835 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How do I execute a file from within a PHP script with headers already sent? 5 21
Advice in Xamarin 21 57
updating the date data 12 25
Session timeout 5 15
If you haven’t already, I encourage you to read the first article (http://www.experts-exchange.com/articles/18680/An-Introduction-to-R-Programming-and-R-Studio.html) in my series to gain a basic foundation of R and R Studio.  You will also find the …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
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 viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

861 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now