[Mysql] Redirect path of ibdata1 and iblog_files

Kunsheng · 10-21-2009, 08:50 AM

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

TB0ne · 10-21-2009, 10:10 AM

Quote:

Originally Posted by Kunsheng

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.

chrism01 · 10-21-2009, 09:00 PM

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.

Kunsheng · 10-21-2009, 11:25 PM

Thanks. Is there some 'best' value for innodDB_per_table ? Or just grant 1 for it?

Quote:

Originally Posted by chrism01

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.

chrism01 · 10-22-2009, 01:43 AM

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.

Kunsheng · 10-23-2009, 09:57 AM

Thanks. The increasing ibdata1 (no decrease) file seems as a bug in mysql.

Quote:

Originally Posted by chrism01

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.