Re: [MonetDB-users] underlying storage

Mag Gam wrote:

Can you explain to me more about this mmaping? I was really going for the NFS solution. http://en.wikipedia.org/wiki/Memory_mapped_files

On Sat, Aug 1, 2009 at 1:24 AM, Stefan de Konink wrote:

...

On Fri, 31 Jul 2009, Mag Gam wrote:

...

Interesting, what filesystem have you used? For benchmarking I know that EXT3 is not an option; lets say the OpenStorage sequential output hit so badly that it was 10 times as slow as the input. With 128GB of RAM that is 'kinda' odd.

...

We are planning to use a simple NFS filesystem. Would that have any problems? I would only use NFS in a shared storage, envirionment not to support databases, serious locking issues and mmaping (like MonetDB does) from NFS is asking for out of memory conditions on Linux (Xen does something in the same way for images, this is not what you want).

If you are just going to support your database from storage and you do not share it. I would just create a volume export that over iSCSI and go XFS over it on Linux. That would also allow snapshotting in an easier way than NFS would do.

Stefan

------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users