I read in Russian the talk which I presented at MySQL Conference & Expo this year. Really it was not exactly same, but some parts existed in both. And there was one of my friends who heard the talk in Russian at the conference. He didn't attend English version, but when it finished he came and asked: "Did you say the most important?" "The most important what?" "Why people can not connect to MySQL"

So here is most important part of my talk :)

And if go through our bugs database you will see enormous quantity of bug reports with similar synopsis: "I can not connect to my fresh installed MySQL". Why does it happen?

Major reason is localhost has special meaning. This problem can look different, but has same route.

Favorite problem of Windows …

Found in the libstdc++ docs:

Extremely weird solutions. If you have access to the compiler and linker at runtime, you can do something insane, like figuring out just how many bits you need, then writing a temporary source code file. That file contains an instantiation of bitset for the required number of bits, inside some wrapper functions with unchanging signatures. Have your program then call the compiler on that file using Position Independent Code, then open the newly-created object file and load those wrapper functions. You’ll have an instantiation of bitset for the exact N that you need at the time. Don’t forget to delete the temporary files. (Yes, this can be, and has been, done.)

Oh yeah – feel the love.

Brought to you by the stl-is-often-worse-for-you-than-meth dept.

While at the MySQL Conference, I caught up with Barry Abrahamson, the systems wrangler/de-facto DBA behind Wordpress.com (and all other Automattic properties). Watch the video.

You probably already know that Wordpress itself is built on top of MySQL. And despite everything you might have heard about our (MySQL/Sun’s) new founders, Wordpress is MySQL today, and for the foreseeable future. Anyway, I digress.

Wordpress.com has about 70 million tables, and tens of thousands of blogs. Large amount of tables, serve for easy sharding - …

I’m pleased with the results of Kontrollbase so far. We’ve had 87 downloads in the last month without any official promotion other than this blog and syndication to planet.mysql.com - so thank you to all of those users that are trying out the application. I’d love to hear your thoughts.. Any feedback about the installation process, the client setup, documentation, and general usefulness would be great. So if you have used it please take a quick minute to leave a comment or send me an email. Thanks everyone, and remember you can always post improvements or bugs at the following link: http://code.google.com/p/kontrollbase/issues/entry

So, is Oracle’s acquisition of Sun good for MySQL or not so much?  And, specifically what does it mean for data warehousing on MySQL, which is one of the top 5 use cases for the leading open source database?  While there are mixed views in the market about the fate of MySQL, it’s usually pretty easy to predict Oracle’s behavior - they are a for-profit company looking to maximize their return on investment and protect their own commercial database business. 

For what they’re worth, my own views on the subject can be summarized as follows: 

• (1) Oracle will not kill MySQL. As I mentioned to Scott Denne from VentureWire the week of the Oracle/Sun …

Last year, Erik Ljungstrom (sensei in the #ourdelta IRC channel on Freenode) created patch for a bug Arjen identified with the handling of (among others) the open-files-limit option; the patch was first included in the OurDelta build of MySQL 5.0.67.

Now, Sun engineer Guilhem Bichot has committed the (modified) patch into the 6.0-maria tree, so it should appear in 6.0 and potentially 5.4. That’s good.

See http://bugs.mysql.com/40368 for details and history.

I was taking notes during “Open Q&A: Feature Request Bonanza” session at the Percona Performance conf. The session started at 9 pm at the last day of the conference, so the room wasn’t as full as it was for other sessions, but still there was an interesting discussion. I’ve missed several requests but more than 90% of stuff is there.

DISCLAIMER People are mentioned when I could both identify them (I was in the first row which rules out those in the back) and had time to note that, so names below are contact points and not indication of who was[n’t] there. I was also somewhat tired so please re-check the statements with their authors if you’re going to make any far-reaching conclusions based on the below:

• The first request was for partial index support: create and use indexes that only have records that match a certain condition.
• Pre-allocate space after table creation. Monty: CREATE TABLE …

I was shown an item of interest to me this morning over at ye olde Xaprb’s blog:

Why MySQL might not benefit from having a mothership

The bit that caught my eye, shortly into the post itself, was:

The conversation went something like “I was talking to so-and-so, and he said, you know, you guys really need Sun/MySQL, because without the mother ship, things will fall apart and your own business will fail.”

While at the User Conference I had a conversation with a colleague o’ his on this very subject, causing me to wonder if the aforementioned “he” is in fact “me”.  Assuming so, that is not at all what I said, so I’ll try again.

My employer has nothing to do with anything I write here, etc.

Everyone Needs the MySQL …

Most of my blog entries this week are going to be at http://web.mac.com/george.trujillo since I'm at the Collaborate 09 Users conference.

I will be hosting a webinar on May 7 about how companies like Wikimedia and Smugmug are using Open Storage and MySQL to deliver rich media (photos, videos) to their users. You can view the webinar live or on demand here.