Uh, you want to store your tablespaces on a NFS mount? Although that should be possible, you certainly don't want that - your performance will drop drastically! So, don't... If you want to try it anyway you should use NFSv4 and TCP (instead of UDP).
JM2C, Oliver On 21/10/09 15:43, Kunsheng Chen wrote: > Just found out the increase of ibdata1 is reported as a bug in Mysql. > > The thing is that Mysql is eating up my space in /var, but I have some in a > NFS system. > > Possible to direct the data path to NFS ? I prefer to that to a risk of > crashing my system. > > Any idea is well appreciated, > > > > Thanks, > > -Kun > > > --- On Tue, 10/20/09, Slawomir Rzeznicki <[email protected]> wrote: > >> From: Slawomir Rzeznicki <[email protected]> >> Subject: Re: [boinc_dev] Backup Mysql databases for the project >> To: "BOINC_dev" <[email protected]>, "Kunsheng Chen" >> <[email protected]> >> Date: Tuesday, October 20, 2009, 7:29 AM >> >> >> >> >> >> >> >> You can fix the >> problem with the database file >> size by setting innodb_file_per_table option in your >> mysql config file. >> >> Instead of one large file, >> it will tell the >> database engine to split the entire database into >> smaller files, one >> file per table. >> This makes database >> maintenance, optimization and >> backups much easier and increases performance, >> especially on machines with >> not enough RAM to keep the entire DB cached in memory. >> >> As far as I remember, >> after switching to >> innodb_file_per_table you have to do ALTER TABLE (or >> OPTIMIZE, but for InnoDB >> it's mapped to ALTER anyway) for each InnoDB table to >> make it 'jump out' from >> the ibdata to a separate file. >> It won't make the >> ibdata file smaller however, >> but the file won't be used anymore. >> >> >> /TJM >> >> >> On Mon, 19 Oct 2009 >> 21:56:05 -0700 >> (PDT) >> Kunsheng Chen <[email protected]> >> wrote: >>> Mysql in my >> project is getting huge because of that >>> 'ibdata1' file. >>> >>> I >> am thinking of backup databases and restore after >>> delete >> 'ibdata1'. >>> Recall I did tell the ./make_project script the mysql >>> user name and password when created the project long >> time >> >>> ago. >>> >>> I am wondering if a backup of the project >> database is >>> enough for that ? >>> >>> Also my file 'ibdata1' is >> getting too huge (16GB), it was >>> caused by some innodb settings. The >> thing I am worried is >>> that after deleting ibdata1 and restart, it will >> getting >>> back to that size again. >>> >>> >>> Any idea >> ? >>> >>> Thanks, >>> >>> -Kun >>> >>> >>> >>> _______________________________________________ >>> boinc_dev mailing >> list >>> [email protected] >>> http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev >>> To >> unsubscribe, visit the above URL and >>> (near bottom of page) enter your >> email address. >> >> >> >> > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > _______________________________________________ > boinc_dev mailing list > [email protected] > http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev > To unsubscribe, visit the above URL and > (near bottom of page) enter your email address. _______________________________________________ boinc_dev mailing list [email protected] http://lists.ssl.berkeley.edu/mailman/listinfo/boinc_dev To unsubscribe, visit the above URL and (near bottom of page) enter your email address.
