Hello, Another consideration besides the performance aspects, are the characteristics between MEMORY and the NDB storage engines. (You'll be gaining or losing functionality depending on how you look at it.)
Briefly: MEMORY - in memory, table locks, hash & B-tree indexes, no disk i/o or persistence NDB - in memory, supports transactions, persistence, row-level locks, hash & T-tree indexes Also, moving to cluster means more machines, and as stated by Kishore, Cluster really buys you scalability, not necessarilly performance right off the bat (unless you plan on using the NDB API to access data.) As, Sherri suggests another storage engine might be a better play here. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX -----Original Message----- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 11:11 AM To: Jan Kirchhoff Cc: mysql@lists.mysql.com Subject: Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster? Why are you using a heap table? My company has tables with much more information than that, that get updated much more frequently. We use InnoDB tables, with very large buffer sizes and have tweaked which queries use the cache and which don't, on a system with lots of RAM (10Gb). Basically we've set it up so everything is in memory anyway. Perhaps a similar setup would help for you? Sincerely, Sheeri Kritzer On 1/27/06, Jan Kirchhoff <[EMAIL PROTECTED]> wrote: > Hi, > > Did anybody ever benchmark heap-tables against a cluster? > I have a table with 900.000 rows (40 fields, CHARs, INTs and DOUBLEs, > Avg_row_length=294) that gets around 600 updates/sec (grouped in about > 12 extended inserts a minute inserting/updating 3000 rows each). This > is currently a HEAP-table (and get replicated onto a slave, too). I > experience locking-problems on both the master and the slave, queries > that usually respond within 0.0x seconds suddenly hang and take 10 > seconds or sometimes even longer. I wonder if a cluster setup would > give me any speedup in this issue? I will be doing some benchmarking > myself next week, but It would be very helpful if anybody could share > experiences with me so I don't have to start from scratch... It is > difficult and very time-consuming to set up a test-suite comparable to > our production systems... Any tips will help! Thanks! > > regards > Jan > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
