[clue] seeking advice cleaning up root

[chris fedde]

Ray,

I'd be very interested in seeing references describing this concern
with the use of symbolic links for relocating databases and tables in
MySQL.    All I can find is this url
http://dev.mysql.com/doc/refman/5.5/en/symbolic-links.html which
encourages and describes exactly how to use the technique. Perhaps the
pivotal sentence in the description is this one:

"The recommended way to do this is simply to symlink databases to a
different disk."

thanks
Chris

On Mon, Mar 21, 2011 at 12:05 PM, Raymond DeRoo <rderoo at deroo.net> wrote:
> Matt--
>
>> I was out at a job site and the clients were having space problems.
>> They were told specifically _by_ MySQL folks to use symlinks for their
>> Innodb dirs.
>
> That would really surprise me, especially considering InnoDB doesn't make use of directories unless innodb_file_per_table = 1 is set, and then one is playing games with the database storage structure itself. No I am not saying it can't be done, but I would be surprised if it was a recommended approach. Why wasn't more disk added?
>
>> So while some MySQL support folks may discourage the use of symlinks,
>> others say it's just fine.  Like everything in life it seems, there is
>> no 'one way' of doing something.
>
> I will also say that most "MySQL Consultants" where third party contractors and did not actually work for MySQL. I've had RHCE tell me that running RH without swap space is fine. "If the machine needs to swap you're already in trouble." Though there is some truth that to that statement, giving the swapper *no where* to go only further compounds that issue.
>
> .r
>
> _______________________________________________
> clue mailing list
> clue at cluedenver.org
> http://cluedenver.org/mailman/listinfo/clue
>