… for XFS file system on a raw partition I was using full partition size which was slightly over 1TB… the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important… misaligned IO. Here’s diskstats from the two shards running side by side: Aligned: #ts device rd…
Comment: Shard-Query adds parallelism to queries
February 24, 2011 By 16 Comments
… hard is it / would it be to integrate cluster-db / shard-query with mondrian for doing olap cubes? Also, how hard would it be to modify shard-query to work with sqlite3 db’s vs. mysql. I’m thinking of using… load/performance for doing sqlite would be ok if i partition the tables often enough, since queries would be read-only…
