LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-21-2009, 08:50 AM   #1
Kunsheng
Member
 
Registered: Mar 2009
Posts: 82

Rep: Reputation: 16
[Mysql] Redirect path of ibdata1 and iblog_files


The ibadata1 and iblog_files are eating up space in my server, but I have lots in an NFS system mounted in the server.


Is it some reliable way to configure that path inside my.cnf ?(or would it be possible ?)

I am using Ubuntu 7.10 with Mysql-5.0 in this case.

Any idea is well appreciated,


Thanks,

-Kun
 
Old 10-21-2009, 10:10 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,950

Rep: Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029
Quote:
Originally Posted by Kunsheng View Post
The ibadata1 and iblog_files are eating up space in my server, but I have lots in an NFS system mounted in the server.


Is it some reliable way to configure that path inside my.cnf ?(or would it be possible ?)

I am using Ubuntu 7.10 with Mysql-5.0 in this case.

Any idea is well appreciated,
Thanks,

-Kun
Possible? Yes...you can either modify the config file, or shut down mysql, move the files, then make symbolic links back to their original locations.

However, I'd never put database related files on an NFS share...too much latency, and chances are, it'll cause problems. Best thing I could suggest is adding more 'real' disk, or moving some other file(s) to NFS to make room.
 
Old 10-21-2009, 09:00 PM   #3
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 7.7 (?), Centos 8.1
Posts: 17,873

Rep: Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600
Use this to convert your system to a separate file per db/schema: http://muzso.hu/2009/08/24/convert-g...er-table-files.
I agree, NFS is not really recommended, unless the DB is on the server end.
 
Old 10-21-2009, 11:25 PM   #4
Kunsheng
Member
 
Registered: Mar 2009
Posts: 82

Original Poster
Rep: Reputation: 16
Thanks. Is there some 'best' value for innodDB_per_table ? Or just grant 1 for it?



Quote:
Originally Posted by chrism01 View Post
Use this to convert your system to a separate file per db/schema: http://muzso.hu/2009/08/24/convert-g...er-table-files.
I agree, NFS is not really recommended, unless the DB is on the server end.
 
Old 10-22-2009, 01:43 AM   #5
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 7.7 (?), Centos 8.1
Posts: 17,873

Rep: Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600
If you read the manual http://dev.mysql.com/doc/refman/5.0/...blespaces.html & http://dev.mysql.com/doc/refman/5.0/...file_per_table, you'd see that its just a toggle; it doesn't take a value (at all).
See also my first link.
 
Old 10-23-2009, 09:57 AM   #6
Kunsheng
Member
 
Registered: Mar 2009
Posts: 82

Original Poster
Rep: Reputation: 16
Thanks. The increasing ibdata1 (no decrease) file seems as a bug in mysql.

Quote:
Originally Posted by chrism01 View Post
If you read the manual http://dev.mysql.com/doc/refman/5.0/...blespaces.html & http://dev.mysql.com/doc/refman/5.0/...file_per_table, you'd see that its just a toggle; it doesn't take a value (at all).
See also my first link.
 
  


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] is anyway to get rid of ibdata1 and iblog_file? Kunsheng Linux - Software 1 10-21-2009 12:34 AM
Mysql: Is it OK to delete ibdata1 under /var/lib/mysql ? Kunsheng Linux - Software 8 09-26-2009 09:28 PM
mysql ibdata1 is very large 95% drive in use - dropped tables but size ibdata remains guest Linux - Server 2 03-20-2009 12:53 PM
Redirect path in csh script ling_ss Linux - Newbie 6 03-15-2009 12:34 PM
Mysql - Need to move ibdata1 file helpmhost Linux - Server 4 07-10-2008 09:30 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:11 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
Open Source Consulting | Domain Registration