On Wed, 1 Oct 2008, Ram Sharma wrote: > So for storing 1 million MYISAM tables (MYISAM being a good performer when > it comes to not very large data) , I need to save 3 million data files in a > single folder on disk. This is the way MYISAM saves data. > I will never need to do an ls on this folder. This folder(~database) will be > used just by MYSQL engine to exceute my SQL queries and fetch me results.
As long as you do not need to list the files in the directory, I think that you will be ok with zfs: First access: % ptime ls -l 'image.dpx[0000666]' -r--r--r-- 8001 bfriesen home 12754944 Jun 16 2005 image.dpx[0000666] real 0.023 user 0.000 sys 0.002 Second access: % ptime ls -l 'image.dpx[0000666]' -r--r--r-- 8001 bfriesen home 12754944 Jun 16 2005 image.dpx[0000666] real 0.003 user 0.000 sys 0.002 Access to a file in a small directory: % ptime ls -l .zprofile -rwxr-xr-x 1 bfriesen home 236 Dec 30 2007 .zprofile real 0.003 user 0.000 sys 0.002 Bob ====================================== Bob Friesenhahn [EMAIL PROTECTED], http://www.simplesystems.org/users/bfriesen/ GraphicsMagick Maintainer, http://www.GraphicsMagick.org/ _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
