List:Cluster« Previous MessageNext Message »
From:Moses Date:May 6 2011 8:32pm
Subject:Re: MySQL Cluster -- Table Full
View as plain text  
Hi Johan,

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)..

Thanks Johan,

Moses.

Thread
MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
  • Re: MySQL Cluster -- Table FullAdam Dixon30 Sep
    • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
  • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
    • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
      • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
        • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
          • Re: MySQL Cluster -- Table FullJonas Oreland30 Sep
            • Re: MySQL Cluster -- Table FullJohan Andersson30 Sep
              • Re: MySQL Cluster -- Table FullKarl Kloppenborg30 Sep
                • Re: MySQL Cluster -- Table FullJohan Andersson30 Sep
                  • Re: MySQL Cluster -- Table FullKarl Kloppenborg1 Oct
                    • Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm1 Oct
                      • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct
                        • Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm7 Oct
                      • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct
                      • Re: MySQL Cluster -- Table FullJon Stephens1 Oct
  • Re: MySQL Cluster -- Table FullMoses28 Apr
    • Re: MySQL Cluster -- Table FullJohan Andersson28 Apr
  • Re: MySQL Cluster -- Table FullMoses6 May
Re: MySQL Cluster -- Table FullAaron Weller // Crucial Paradigm1 Oct
  • Re: MySQL Cluster -- Table FullJohan Andersson1 Oct