Lue ; mysql
> Sent: Wed, November 25, 2009 8:12:25 PM
> Subject: Re: question regarding mysql database location
>
> Dear Johan,
>
> Need your help again in understanding How mysql reads symlink.
>
> As you said below, I have created symlinks in default mysql directory.
&
Hi Johan,
It worked perfectly. Thank you so much for this explanation.
I am really greatful.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save <
> manasi.s...@artificialmachines.com> wrote:
>
>> Dear Johan,
>>
>> Need your help again in un
Is mysql the owner of the directories?
- Original Message
From: Manasi Save
To: Johan De Meersman
Cc: Waynn Lue ; mysql
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding mysql database location
Dear Johan,
Need your help again in understanding How mysql reads
On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Dear Johan,
>
> Need your help again in understanding How mysql reads symlink.
>
> As you said below, I have created symlinks in default mysql directory.
> and try to read that symlink file as a database. B
Dear Johan,
Need your help again in understanding How mysql reads symlink.
As you said below, I have created symlinks in default mysql directory.
and try to read that symlink file as a database. But mysql is not reading
that file as Database. Is there any settings which I need to change.
Thanks
Thanks Johan,
It was really a great help. I'll try to implement it. I dont want to opt
for multiple mysql instances option as thats not feasible.
I'll get back to you all if it works fine.
Thanks again.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 11:55
On Wed, Nov 25, 2009 at 12:05 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> At a time mysql can point to one data directory. For your task you can have
> n number of mysql installation with different data directory. After that
> you
> can use federated storage engine to perform y
On Wed, Nov 25, 2009 at 11:55 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi Johan,
>
> I am Sorry. If I have complicated the senerio But, this still not fix my
> purpose.
>
> What I want is - From your example :-
>
> /data/disk1/mysql/db1 (directory)
> /db2 (dir
Hi Manasi,
At a time mysql can point to one data directory. For your task you can have
n number of mysql installation with different data directory. After that you
can use federated storage engine to perform your task.
Thanks,
Krishna Ch. Prajapati
On Wed, Nov 25, 2009 at 12:19 PM, Manasi Save <
Hi Johan,
I am Sorry. If I have complicated the senerio But, this still not fix my
purpose.
What I want is - From your example :-
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
You don't need to move any databases. Look at this structure:
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
/db5 (symlink to /data/disk2/mysql/db5)
/db
Well Waynn,
In this case I need to move all the existing databases to new location
right. Which I don't want to do. Is it possible that I create sym link
between two and use both.
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
>
On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Thanks Waynn,
>
> I could not get your point of using symlinks. Because as per my knowledge
> symlink will store same data which is there in original directory.
> and What do you mean by "The limit for fil
Thanks Waynn,
I could not get your point of using symlinks. Because as per my knowledge
symlink will store same data which is there in original directory.
and What do you mean by "The limit for files is significantly higher than
> directories."
Can you elaborate it more.
Thanks in advance.
Rega
I fixed this by using symlinks for the directories for the underlying
databases. The limit for files is significantly higher than
directories.
Waynn
On 11/24/09, Manasi Save wrote:
> Hi All,
>
> I have asked this question before But, I think I am not able to describe
> it better.
>
> Sorry for a
Also I forgot to mention that I have gone through the innodb option of
innodb_data_file_path but I can just specify it as :
innodb_data_file_path=ibdata1:2048M:autoextend:max:1024M;ibdata1:2048M:autoextend:max:1024M;
But not as :
innodb_data_file_path=/var/lib/mysql/data/ibdata1:2048M:autoextend
16 matches
Mail list logo
