[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 |
Quote:
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. |
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. |
Thanks. Is there some 'best' value for innodDB_per_table ? Or just grant 1 for it?
Quote:
|
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. |
Thanks. The increasing ibdata1 (no decrease) file seems as a bug in mysql.
Quote:
|
All times are GMT -5. The time now is 07:26 AM. |