In the last episode (Oct 08), Ace said:
> On 10/7/07, Dan Nelson <[EMAIL PROTECTED]> wrote:
> > In the last episode (Oct 06), Ace said:
> > > You all know the size problems with ibdata and log files. We plan
> > > to move those files to SAN to have maximum storage possible. We
> > > did so with con
Rajan,
I believe you are talking about a NAS setup, which is different from
the SAN configuration I was referring to. Check out
http://www.nas-san.com/differ.html for a quick comparison.
With NFS volumes, your adding several layers of overhead when
accessing the disks which has a drastic effe
Yes Scott! Only thing that confused and still confusing me is the following
note on mysql site -
"*Note*
It is not a good idea to configure InnoDB to use datafiles or logfiles on
NFS volumes. Otherwise, the files might be locked by other processes and
become unavailable for use by MySQL. "
http:/
Rajan,
In a SAN configuration, the lun/volume should appear just like a
locally attached physical disk on your server. MySQL will not need any
special configurations to access it, just poiint the datadir to the SAN
disk.
Regards,
Scott Tanner
On Mon, 2007-10-08 at 11:06 +0530, Ace wrote:
> Tha
Thanks Dan! We do know the permission problem. We tried chown but got "Not a
owner" error. That is because of "root squashing" in which root becomes
"nobody" when you cd to NFS directory.
To overcome this we tried adding "no_root_squash" to export file. but
still the error.
I will overcome thi
In the last episode (Oct 06), Ace said:
> Hi Experts,
>
> You all know the size problems with ibdata and log files. We plan to
> move those files to SAN to have maximum storage possible. We did so with
> configuration changes in my.cnf files to save log and ibdata files on SAN
> location. Bu
Hi Experts,
You all know the size problems with ibdata and log files. We plan to
move those files to SAN to have maximum storage possible. We did so with
configuration changes in my.cnf files to save log and ibdata files on SAN
location. But got following error -
InnoDB: Unable to lock /ops
