Re: [zfs-discuss] ZSF Solaris

[Ram Sharma]

Hi Guys,

Thanks for so many good comments. Perhaps I got even more than what I asked for!

I am targeting 1 million users for my application.My DB will be on solaris 
machine.And the reason I am making one table per user is that it will be a 
simple design as compared to keeping all the data in single table.In that case 
I need to worry about things like horizontal partitioning which inturn will 
require higher level of management.

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.
And now that ZFS allows me to do this easily, I believe I can go forward with 
this design easily.Correct me if I am missing something.
--
This message posted from opensolaris.org
___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss

[zfs-discuss] ZSF Solaris

[Ram Sharma]

Hi,

can anyone please tell me what is the maximum number of files that can be there 
in 1 folder in Solaris with ZSF file system.

I am working on an application in which I have to support 1mn users. In my 
application I am using MySql MyISAM and in MyISAM there is 3 files created for 
1 table. I am having application architechture in which each user will be 
having separate table, so the expected number of files in database folder is 
3mn. I have read somewhere that there is a limit of each OS to create files in 
a folder.
--
This message posted from opensolaris.org
___
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss