{"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":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/03\/01\/mysql64-bit-and-memory-allocation","title":{"rendered":"MySQL\/64-bit and memory allocation"},"content":{"rendered":"

So, earlier today I was playing around with compiling<\/a> MySQL on a 64-bit platform, as there was a 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 make test<\/code> to see if I could make it run into problems.<\/p>\n

I couldn’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

So my question to readers are:<\/p>\n

    \n
  1. 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
  2. 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

    If you answered yes to any of the above, do drop me e-mail at colin@mysql.com<\/a>, or comment here. Thanks.<\/p>\n

    In other interesting news, Jay<\/a>, my colleague presented a webminar on 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 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

    Oh, and MySQL 5.1 just hit beta. Seeing my iPod 3G died, maybe its time to make MySQL rock and 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!
    \n(yes, yes, I know I can’t get to win an iPod Nano)<\/small><\/p>\n

    Share this:<\/h3>