I see this to often; Storing HTML in the database. Then UI wants to change the HTML, but the data grew to 100 GB, so the really only feasible way to change the HTML is via a post process after the database fetch. This post process produces a huge list of preg_replace statements to rebuild the HTML on display. This consumes a lot of memory over time and slows down the APP, plus its time consuming to debug.


Store URLS if the apps need to. Or better yet build the schema to store the bare minimum the app needs to generate the HTML.

Here is a compelling reason why not to store HTML:

The data needed to generate the HTML is 10 bytes, but the TEXT field consumes 1024 bytes, all of which is the same text.

Thus for an app that should cost very little to maintain now costs 10 times as much.

If your building a search engine strip out the HTML and store the text. If its a quick …

I will be speaking at Community One in San Francisco, the Sun event immediately before Java One.
The session is Creative Programming with MySQL, which is an euphemism for "hacking MySQL" :).
I will cover the basics of programming MySQL independently of your language of choice, using stored routines, storage engines, triggers, events, and MySQL Proxy.

Track: Databases
Room: Esplanade 307
Date: 2008-05-05
Start Time: 12:25

If you are in the area, come along!

We had over 400 participants in yesterday’s MySQL-Sun event in China! Plus another 30 or so in the press event, happening in parallel.

Beijing, if nobody noticed, is preparing for the Olympics. Here’s the so called Birds Nest, that we passed several times on the way to various meetings — including yesterday’s event.

After initial linguistic difficulties, Larry Stefonic (MySQL VP APAC) found our way to the event.

This was the first MySQL-Sun event with a banner across a street!

Everything takes place in Chinese here. About as much as it’s Japanese in Japan. In Europe, we seem to give way too much way for English.

And to accommodate to the local situation, I gave my presentation (on MySQL-Sun integration) in Chinese. It was about 8 minutes, and I was happy to be several times interrupted for applause. And I didn’t say anything …

My name is Karl Van den Bergh — I do Business Development here at Kickfire. I’ll be joining Raj on our corporate blog adding my comments to what is happening at our company and in our marketplace.

What a great conference (my first) and what a great venue it was to have launched our company and beta product.

Now that I have switched from the dark side of commercial software to the open source world, my eyes have been opened to the power of the community. Specifically, the success of our launch can, to a large degree, be attributed to the community.

Over the last couple of weeks I have heard comments in the blogosphere to the effect that Kickfire has a great marketing machine. One blog noted that Kickfire had “brought Web 2.0 Marketing to the Database World.” Whereas our marketing team will certainly take pride in these comments (and should for all the hard work that went into this launch), the reality is that our …

I’m not sure how I didn’t see this earlier, but it looks like MySQL 5.1 is coming with a load balancer for replicated servers. I’m absolutely pumped about this - we’ve got a few sites running with multiple db slaves and it’s so annoying having to check if they’re behind the master.

It looks like the load balancer will automatically pull slaves out if they fall behind, and route connections to the ones that are the most up to date. It is based on MySQL Proxy, which is currently in Alpha.

MySQL Load Balancer

The new version is avaialble for download.

In this release:

- added: windows port
- added: multitable select star warning
- added: multicolumn IN clause warning
- added: numeration for output messages

- fixed: bug 0000001: Compilation fails
(a compilation problem on 3.x g++ compilers)

The big news coming from Java One is that Sun is removing the last licensing hurdles in Java. What this means is Java is becoming fully Open Source.

Java users can especially thank Sun now. Also this supports Sun's vision of Open Source.

"We've been engaging with the open-source community for Java to finish off the OpenJDK project, and the specific thing that we've been working on with them is clearing the last bits that we didn't have the rights," to distribute, Sands said.

"Over the past year, we have pretty much removed most of those encumbrances," Sands said. Work still needs to be done to offer the Java sound engine and SNMP code via open source; that effort is expected to be completed this year. Developers, though, may be able to proceed without a component like the sound engine, Sands said.
Source: …

The conference that many of us just went to is called the MySQL Conference and Expo, but a lot of people don’t call it that. They call it by the name it had in 2006 and earlier: MySQL User’s Conference. In fact, some people say (or blog) that they dislike the new name and they’re going to call it the old name, because [… insert reason here…].

I call it by the new name that some people dislike so much. Why? Because it is a conference and expo, not a user’s conference. There’s no reason to pretend otherwise. The conference is organized and owned by MySQL, not the users. It isn’t a community event. It isn’t about you and me first and foremost. It’s about a company trying to successfully build a business, and other companies paying to be sponsors and show their products in the expo hall. Times have changed.

I’m not saying any of this is bad. Being successful in …

This article provides a comparison between the MyISAM and InnoDB storage engines for MySQL. InnoDB is commonly considered to perform worse than MyISAM, but this article aims to dispel this myth by describing the differences between these engines and what makes InnoDB a good fit for many database needs.

In addition, a look at when it is better to use MyISAM and a case study of the drupal.org site provide insight for determining which engine is best for a given situation.

read more