{"id":586,"date":"2006-02-17T11:30:40","date_gmt":"2006-02-17T01:30:40","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2006\/02\/17\/ndb-disk-requirements\/"},"modified":"2006-02-17T11:30:40","modified_gmt":"2006-02-17T01:30:40","slug":"ndb-disk-requirements","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2006\/02\/17\/ndb-disk-requirements\/","title":{"rendered":"NDB Disk Requirements"},"content":{"rendered":"<p>up to 3 copies of data (3*DataMemory)<\/p>\n<p>+ 64MB * NoOfFragLogFiles (default=8)<\/p>\n<p>+ UNDO log (dependent on update speed)<\/p>\n<p>For example:<\/p>\n<p>DataMemory=1024MB<\/p>\n<p>idea on disk usage= 1024*3 + 64 * 8 =\u00c2\u00a0 3584MB + UNDO log<\/p>\n<p>It&#8217;s very tempting to have a &#8220;SHOW ESTIMATES&#8221; command in the management client\/server that performs all these equations (and the answers). I bet Professional Services would love me :)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>up to 3 copies of data (3*DataMemory) + 64MB * NoOfFragLogFiles (default=8) + UNDO log (dependent on update speed) For example: DataMemory=1024MB idea on disk usage= 1024*3 + 64 * 8 =\u00c2\u00a0 3584MB + UNDO log It&#8217;s very tempting to &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2006\/02\/17\/ndb-disk-requirements\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[14],"tags":[],"class_list":["post-586","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-9s","jetpack-related-posts":[{"id":1124,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/06\/18\/ndbinfo-scanning-from-ndb_mgm\/","url_meta":{"origin":586,"position":0},"title":"NDB$INFO scanning from ndb_mgm","author":"Stewart Smith","date":"2008-06-18","format":false,"excerpt":"In code just tested: ndb_mgm> ndbinfo MEMUSAGE RESOURCE_NAME\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 NODE_ID\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 PAGE_SIZE_KB\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 PAGES_USED\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 PAGES_TOTAL\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 BLOCK IndexMemory,1,8192,16,160,DBACC DataMemory,1,32768,20,640,DBTUP IndexMemory,2,8192,16,160,DBACC DataMemory,2,32768,20,640,DBTUP Win! This is the first time that we've been able to get this kind of info out of the cluster without using the magic \"all dump 1000\" (or \"all report MemUsage\") which end\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":587,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/02\/17\/ndb-disk-io-patterns-redo-and-undo-logs\/","url_meta":{"origin":586,"position":1},"title":"NDB Disk IO patterns &#8211; REDO and UNDO Logs","author":"Stewart Smith","date":"2006-02-17","format":false,"excerpt":"(stolen out of Mikael's post to the cluster list - http:\/\/lists.mysql.com\/cluster\/2396) Both REDO and UNDO logs are stored in buffers but are sent after a while to disk. For REDO the disk write happens when 256 kByte of buffer is filled up or when a GCP requests synching the data\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":926,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/05\/27\/ndbinfo\/","url_meta":{"origin":586,"position":2},"title":"NDB$INFO","author":"Stewart Smith","date":"2008-05-27","format":false,"excerpt":"There's been talk over the years of better monitoring for NDB (MySQL Cluster). This has been dubiously named NDB$INFO, after some special magical naming convention for tables holding information on the insides of NDB. Otherwise known as Worklog 3363 (viewable on MySQL Forge). The basic idea is to get a\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":805,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/03\/17\/ndb-online-add-node-progress-or-rather-testing-it\/","url_meta":{"origin":586,"position":3},"title":"NDB Online Add Node Progress (or rather, testing it)","author":"Stewart Smith","date":"2007-03-17","format":false,"excerpt":"So, the sitch as of today: Added ndb_mgm_set_configuration() call to the mgmapi - which is not-so-casually evil API call that sends a packed ndb_mgm_configuration object (like what you get from ndb_mgm_get_configuration) to the management server, who then resets its lists of nodes for event reporting and for ClusterMgr and starts\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":767,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/12\/11\/online-online-online-or-restarts-are-for-wusses\/","url_meta":{"origin":586,"position":4},"title":"online online online! (or restarts are for wusses)","author":"Stewart Smith","date":"2006-12-11","format":false,"excerpt":"I often see things go past my eyes where customers (and users - i.e. those that don't send wads of cash our way and hence are not financially supporting my beer, curry and photography habits) have amazing uptime and reliability requirements. When talking to businesses that use MySQL, it's not\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1051,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/03\/28\/default-filesystem-and-disk-parameters-are-for-wusses\/","url_meta":{"origin":586,"position":5},"title":"default filesystem and disk parameters are for wusses","author":"Stewart Smith","date":"2008-03-28","format":false,"excerpt":"I can't remember the last time i used default mkfs or mount options... oh yeah, that's right - by accident. Anyway... I did a little experiment today. The filesystem is my laptop \/home - XFS, 100GB, 95% used (so 5-6GB free), rather aged. This is where a lot of my\u2026","rel":"","context":"In &quot;linux-kernel&quot;","block_context":{"text":"linux-kernel","link":"https:\/\/www.flamingspork.com\/blog\/category\/linux-kernel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=586"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/586\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}