Hi,
On Mon, Feb 22, 2010 at 10:40 AM, Johan De Meersman wrote:
> I don't think using a dot is a good idea - that's the table.field separator.
Right. Even if mysqld didn't complain about the directory name, just
try using a '.' character in an identifier. It's a syntax error, no
matter how it's
I don't think using a dot is a good idea - that's the table.field separator.
On Fri, Feb 19, 2010 at 12:41 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
>
> Hi Johan,
>
> Some time back you have solved my problem of creating symlink as database
> was fixed. But now When I am putti
efman/5.0/en/innodb-restrictions.html
> -Original Message-
> From: Manasi Save [mailto:manasi.s...@artificialmachines.com]
> Sent: Friday, February 19, 2010 4:20 AM
> To: mysql@lists.mysql.com
> Subject: Re: Using symlinks for database creation in mysql
>
> Hi All,
Hi All,
When I am creating a symlink with a special character in database name
it appears in mysql as somthing like this
#mysql50#dbname.
For Ex:- I have created a symlink in mysql data directory named
"User.Name" which appeared to me in mysql command line client as
"#mysql50#User.Name
Can
Hi Johan,
Some time back you have solved my problem of creating symlink as
database was fixed. But now When I am putting special characters in
symlinks like "." it is not readable as database. If I am creating
database with special characters from mysql command line I can create
it but an sy
Given that you're talking about "quite a few" folders, I think it'd be good
to check up on the theoretical and practical limits for your filesystem of
choice, though - ext2 for example starts getting noticeably slower when you
have a lot more than 10.000 entries in the same directory. One way of
ge
And, IF the application uses the file a lot, but opens it infrequently, for
example an MySQL data file, then the incremental cost is truly neglectable.
IF the symlink is looked up and followed frequently then caches will make it
neglectable.
IF the application touches a wide range (hundreds of th
I don't agree, Don't have any specific documents but seems to make a bit of
sense to me.
Opening a file that is a symbolic link takes more time than one that isn't
as you need to do more operations. Search the directory for the symbolic
link, open it (probably, though an inode look up might be eno
Not a problem as you are doing it from a whole data directory.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 11:56 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
>
> I am creating symlinks as database.
>
> I have mysql data directory created on /var/lib/mysql/dat
