LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 09-27-2008, 12:05 PM   #1
nephish
Member
 
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.
thanks
 
Old 09-27-2008, 12:29 PM   #2
w3bd3vil
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, 12:46 PM   #3
nephish
Member
 
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

thanks
 
  


Reply


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 01:58 AM
MySQL startup process and my.cnf lord-fu *BSD 4 07-11-2007 08:44 AM
Setting up the my.cnf for MySQL Server wbuik Linux - Software 1 09-24-2005 05:33 PM
how to config the mysql my.cnf? treotan Linux - General 1 09-14-2005 12:05 PM
MySQL server & my.cnf hct224 Linux - Newbie 0 04-02-2004 02:03 PM


All times are GMT -5. The time now is 06:12 AM.

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