Many thanks for your reply. Was monitoring your blog for an answer but somehow
got back here via Google ;). Anyway, this is now bookmarked!!
I suppose the burning questions are:
- What is the absolute maximum number of rows per table? Assume each row is 8k
(the maximum allowed per row)
- Can u, for argument's sake, have all 48 data nodes storing data for one table
alone (with/without STORAGE DISK enabled)? Assume 32GB RAM / 750GB HDD nodes..
- The reason i ask is this: for some fast growing tables, u may want to reserve
a cluster for any such table (think email, user tracking, sessions, etc..)
- What is the performance penalty for enabling STORAGE DISK? Does performance
get worse that InnoDB for both reads or writes?
- When can we expect 7.2 as it seems to perform a lot better with joins
(apparently 20 - 25% improvement on 7.1)..