Hi,
On Mon, Feb 22, 2010 at 10:40 AM, Johan De Meersman vegiv...@tuxera.be 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,
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 putting
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
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
/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,
When I am creating a symlink
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
Hi All,I am creating symlinks as database.I
have mysql data directory created on /var/lib/mysql/databasename.on the same path I am creating /var/lib/mydatabaseand creating
symlink from/var/lib/mydatabase to
/var/lib/mysql/databasenamewill there any performance
issues as there will be quite a few
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
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
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
10 matches
Mail list logo