{"id":374,"date":"2006-03-01T23:44:46","date_gmt":"2006-03-02T04:44:46","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=374"},"modified":"2006-03-01T23:46:02","modified_gmt":"2006-03-02T04:46:02","slug":"mysql64-bit-and-memory-allocation","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2006\/03\/01\/mysql64-bit-and-memory-allocation","title":{"rendered":"MySQL\/64-bit and memory allocation"},"content":{"rendered":"<p>So, earlier today I was playing around with <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/installing-source-tree.html\">compiling<\/a> MySQL on a 64-bit platform, as there was a <em>bug<\/em> reported that there were problems allocating a large amount of memory to it. I compiled it, and tried running a few tests beyond the usual <code>make test<\/code> to see if I could make it run into problems.<\/p>\n<p>I couldn&#8217;t. From a chat earlier in the morning, Stefan told me to try a really large table, with a stored procedure that repeatedly queried it. I tried that, but never got my out of memory errors. And my test box had 1GB of RAM.<\/p>\n<p>So my question to readers are:<\/p>\n<ol>\n<li>Have you had grief with MySQL 5 (or later, see 5.1 just hit beta) on a 32-bit or 64-bit platform, where you had issues allocating a large amount of memory to the MySQL server?<\/li>\n<li>Do you have useful test harnesses designed to stress test your greatest\/latest\/newest database installation? How do you, the community QA the next release of MySQL?<\/li>\n<\/ol>\n<p>If you answered yes to any of the above, do drop me e-mail at <a href=\"mailto:colin@mysql.com\">colin@mysql.com<\/a>, or comment here. Thanks.<\/p>\n<p>In other interesting news, <a href=\"http:\/\/jpipes.com\/\">Jay<\/a>, my colleague presented a webminar on <a href=\"http:\/\/www.mysql.com\/news-and-events\/web-seminars\/coding-indexing.php\">Coding and Indexing Strategies for Optimal Performance<\/a>. It was well received, I had a really good time attending it (even though it was at 5am!) and I suggest folk going to these <a href=\"http:\/\/www.mysql.com\/news-and-events\/web-seminars\/\">webminars<\/a>. Sure, it requires an icky Java client, but you do learn a lot following presentations and listening to the presentation. Its like a recorded lecture\/podcast, except its all automated :)<\/p>\n<p>Oh, and MySQL 5.1 just hit beta. Seeing my iPod 3G died, maybe its time to make MySQL rock and <a href=\"http:\/\/dev.mysql.com\/mysql_51_contest.html\">win an iPod Nano<\/a>.  File reproducible bug reports, talk about it, and get picked to win an iPod Nano. 1 given away every week!<br \/>\n<small>(yes, yes, I know I can&#8217;t get to win an iPod Nano)<\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, earlier today I was playing around with compiling MySQL on a 64-bit platform, as there was a bug reported that there were problems allocating a large amount of memory to it. I compiled it, and tried running a few tests beyond the usual make test to see if I could make it run into [&hellip;]<\/p>\n","protected":false},"author":1,"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_feature_clip_id":0,"_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":[23],"tags":[],"class_list":["post-374","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-62","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=374"}],"version-history":[{"count":0,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/374\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}