Using MEMORY tables in MySQL is very useful; they are stored in memory and they are usually not so big in order to avoid a huge utilization of RAM. They are very fast.

MEMORY tables are often used to store session user data, chat messages and to store small frames of data from a bigger table in order to achieve great performance.

But, if you use them in a replication environment, you can have some problem due to their “volatility”; MEMORY table rows are lost when the server shuts down.

If you restart a slave host for some reason, you will have empty MEMORY tables on it, while the master host will have the correct ones.

How to populate automatically MEMORY tables at slave start up copying data from master host?

We could use something like LOAD TABLE table_name FROM MASTER, but it’s deprecated, so we will use something else.

I have developed a stored procedure you have to create on …

One of the challenges we sometimes have at MySQL is that our audience is very broad.  We get hundreds of thousands of page views every day and the interests span a wide range.  That's one of the reasons we created the Developer Zone http://www.dev.mysql.com so that it would be easy for developers to find downloads, documentation and technical articles.  In effect, people who are alergic to buzzwords like ROI, TCO and CIO could bypass the home page and just stick to the technical content on the dev zone. 

Earlier this week, we launched a PR campaign called the 12 Days of Scale Out on our web site in order to highlight some examples of customers who have built very large applications or web sites using MySQL, such as Booking.com, Alcatel, Wikipedia, Zimbra, etc.  The content was targeted towards business …

Build notes and Tuning tips for Solaris

lighttpd seems to be increasingly popular, so much so that netcraft has started tracking it's use on production websites. I've spent some time building, tuning and running simple performance stress tests on lighttpd 1.4.15 on Solaris and thought I'd share what I learnt.

Building lighttpd

My build of lighttpd uses the openldap library from Cool Stack. I also built and installed pcre-7.1 in /opt/coolstack using the following script :

#!/bin/sh
INSTALLDIR=/opt/coolstack
CFLAGS="-fast -xipo -xtarget=generic"

make distclean
./configure --prefix=$INSTALLDIR CFLAGS="$CFLAGS"
make
make install
…

it?s another month, so time for another connector/odbc release.

there?s already three bug fixes that have been committed to the repository for the next release, and the changes to support building on windows x64 should land soon.

we?re down to about 130 open bugs, about 20 less than the last release. some of those were newly fixed, and some were closed because they duplicated earlier problems that had already been fixed. this release does close another bug that is nearly three years old.

one of the things i hope to get fixed for the next release is being able to specify the default character set for the connection. you can?t do this now, so when developers try to use a different default character set …

I've had the site turned off for sometime now.  I just redirected requests for www.bytefx.com to www.bytefx.com/blog.  However, I've been interested lately in putting up some new content so I decided to reactivate the site and thought it would be a good idea to move to the latest version of DotNetNuke.

Well, the first attempt left the side disabled giving some error in the version 4.4 db script about an integer value.  I was  unable to find the error in the log so I'm not sure what the problem was.  So, from there I manually deleted all the database tables and procedures and attempted to setup the "New Install" package of DNN.  Same problem.  Frustrated and wondering if Community Server would setup easier, I tried one last time.  This time I set the objectQualifer to 'dnn4_'.  This is …

We're happy to announce that we have some new members of the Open Sources team of masked banditos. Zack Urlocker of MySQL Savio Rodrigues from IBM Dave Dargo, man of mystery and intrigue Zack started the ball rolling with a post on his recent trip to China.... READ MORE

Solid has released 5.0.41-0073. This release has a number of bug fixes and performance improvements. For the full detailed list of bug fixes and enhancements, please see the ChangeLog.

This is the “collation” release! 5.0.41-0073 supports the UTF8 and UCS2 character sets. In particular, the following collations have been added: {utf8,ucs2}_{bin,general_ci,unicode_ci,swedish_ci}

There is also now full support for all collations in the latin1 character set.

Check it out at http://dev.soliddb.com/download

A good three years ago at the Linux Summit 26-27.2.2004 in the Finlandia Hall in Helsinki, I gave a presentation on “Why MySQL?” together with Osma Ahvenlampi, CTO of Sulake Labs, the creators of Habbo Hotel, one of the world’s largest teen online communities present in 29 countries.

Now, browsing the web pages of COSS, the Finnish Centre for Open Source Solutions, I ran across their …

Well, not very much. I mean, who wants to only scale to hundreds of millions of page views?

Aside from Oracle, that is? ;-)

As Tim notes, MySQL is in the middle of its "12 Days of Scale-out," which is designed to show how MySQL, that little database that could, ...

The 49th edition of Log Buffer, the weekly review of database blogs, has been published by Coskan Gundogar on Coskans Approach to Oracle. The slot for the landmark 50th Log Buffer is still up for grabs. Get in touch to take it on and join the big conversation this is LB! Coskan Gundogar’s Log Buffer #49.