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 enough), find the file it points to and then open that. Furthermore, I believe that an application that opened a symbolic link is only ever going to reference that file via that link (as that's the file handle it got when it opened the thing). This means that all io to and from that file probably needs to go through a longer path. Where you have hundreds of these going on, those additional system calls are going to add up to a degradation in performance. On Fri, Jan 29, 2010 at 12:14 PM, Suresh Kuna <sureshkumar...@gmail.com>wrote: > 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/databasename. > > > > > > on the same path I am creating /var/lib/mydatabase > > > > and creating symlink from /var/lib/mydatabase to > > /var/lib/mysql/databasename > > > > > > will there any performance issues as there will be quite a few folders > and > > symlinks on the same path? > > > > > > Thanks in advance. > > > > > > -- > > Regards, > > Manasi Save > > > > > > > -- > Thanks > Suresh Kuna > MySQL DBA > -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat