Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 09-27-2008, 11:05 AM   #1
Registered: Jun 2005
Distribution: arch, ubuntu
Posts: 456

Rep: Reputation: 30
change to config file MySQL my.cnf does not take

hey all
I am running ubuntu server at work. I have been trying to make MySQL let me create a larger MEMORY table. I have a table, but when it hits the capacity limit, it fails and crashes.
the setting in my.cnf is max_heap_table_size =
the default is 16777216
i am trying to set it to 52428800

i save the file and restart MySQL and when i do a --verbose --help, it shows being set to the default. The my.cnf does not change. I have even tried with the server was running with
set max_heap_table_size = 52428800
and it takes the query no problem, but when i check, i am back at the defautl 16M.

i am restarting the server after changes in the config file.

would really appreciate any tips on this one, kinda pulling my hair out.
Old 09-27-2008, 11:29 AM   #2
Senior Member
Registered: Jun 2006
Location: Hyderabad, India
Distribution: Fedora
Posts: 1,189

Rep: Reputation: 49
Are you sure you are editing /etc/my.cnf ?
Old 09-27-2008, 11:46 AM   #3
Registered: Jun 2005
Distribution: arch, ubuntu
Posts: 456

Original Poster
Rep: Reputation: 30
well, i don't have a /etc/my.cnf file,
it is /etc/mysql/my.cnf

but i think it is the only copy of any my.cnf file



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
mySQL 100% CPU, how to config my.cnf for lots of querys sorigen Linux - Server 2 10-01-2007 12:58 AM
MySQL startup process and my.cnf lord-fu *BSD 4 07-11-2007 07:44 AM
Setting up the my.cnf for MySQL Server wbuik Linux - Software 1 09-24-2005 04:33 PM
how to config the mysql my.cnf? treotan Linux - General 1 09-14-2005 11:05 AM
MySQL server & my.cnf hct224 Linux - Newbie 0 04-02-2004 01:03 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:42 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration