database, mysql, option files, options, status variables

SHOW STATUS and SHOW VARIABLES are very useful features for analyzing server performance, server setup and general debugging. Many times, there are items applicable to a scenario in both lists. Further, sometimes it’s difficult to know whether an option or variable can be changed on the commandline or in an option file.

For example, let’s say you are debugging a lot of aborted connects. You may care about the following items in “SHOW …

I'll have two sessions on upcoming OpenSource Database Conference in Frankfurt 6-8 November. One session will be general MySQL Performance Optimization workshop the other will be focused on Innodb architecture and optimization.

If you're visiting this event or International PHP Conference which runs parallel to this even drop me a note and we can chat.

You also might noticed I was not posting too actively in October - it turned to be very busy month but hopefully I'll get some more time soon

A good rule to remember - all is case sensitive (talking about identifiers), even if it is false it will help you to avoid many problems. But really in MySQL are case sensitive only table and database identifiers and only on platforms with case-sensitive filenames (Linux/Unix). It is so because tables and databases are represented as files (filenames are used as identifiers). And I think there is nothing good in such behavior because it complicates databases portability.

It is interesting, and what about MSSQL and Oracle.

Within hours of yesterday’s blog on a pure PHP driver, Georg Richter had been on the German PHP IRC channel as well as on efnet IRC. Georg wrote an FAQ in German.

“For MySQL’s PHP team (Ulf Wendel, Andrey Hristov and myself), the plan to publish a new library under the PHP license in March 2007 is not only a challenge and a programming task, but also an opportunity to improve upon what we already have“, Georg writes. “The new MySQL differentiation between Community and Enterprise gives us the possibility to speed up the implementation of features essential to PHP, without being as dependent on MySQL release cycles as before“, he concludes his overview.

Then, Georg provides this FAQ, based on the “partly …

On his blog, Jeff Nolan had a humorous photo from Oracle Open World conference this week.  I've seen some other variations out on Flickr (which as most people probably know is built on the open source LAMP stack and MySQL.)

After months of rumors, Oracle's finally come clean on their Linux strategy.  It's not Debian, it's not Ubuntu, but rather, is based on Red Hat Linux. Its good to see Oracle take an aggressive stand …

Oracle Announces The Same Enterprise Class Support For Linux As For Its Database, Oracle (Press Release)

Sourcefire Files Registration Statement for Initial Public Offering, Sourcefire (Press Release)

Red Hat ISV Partner Program Experiences Record Growth of 122% in 2006; Makes Plans for 2007, Red Hat (Press Release)

Fonality Introduces trixbox 2.0 Next-Gen Asterisk-Based Application Platform, Fonality (Press Release)

FiveRuns Announces Support for Oracle …

If you head over here: mysql on bkbits.net you can get a copy of the NDB team trees. This is where we push stuff before it hits the main MySQL trees so that we can get some extra testing in (also for when pulling from the main tree). So you can be relatively assured that this is going to work fairly well for NDB and have the latest bug fixes.

Of course, if anything is going to break here - it’s going to be NDB :)

This should allow you to get easy access to the latest-and-greatest NDB code.

At some point soon I’ll update my scripts that generate doxygen output (and builds) to do the -ndb trees.

enjoy!

There have been some interesting MySQL happenings lately. First we had the Enterprise/Community split. I’ll talk more about that in terms of distributions shipping it, as I’ll be liaising with them.

But today, I’m going to talk about Digg. I listen to Diggnation, a surprisingly funny podcast to keep track of the weekly Web happenings. But I’ve never actually paid the site a visit. Until today.

Its the epitome of Web 2.0. User driven content. Its not like Slashdot. I’ve seen many people compare to it, but it isn’t. Slashdot is for tech-content. Digg is for anything. Slashdot has a bunch of editors. Digg is user-edited.

And for users, if your stories get promoted to the front-page, you get ratings. The more ratings, the merrier, right? It probably also increases the trust model, as higher ratings usually mean that you’ve got good news sense. And we all know …

The Sage Group plc has signed a global agreement with MySQL AB which enables Sage to embed MySQL database technology into its world-wide product portfolio.

Talking to the PHP community members, I see a recurring theme:

How does MySQL integrate with PHP — both from a technical and from a licensing perspective?

MySQL provides several ways to integrate between PHP and MySQL, most notably the ext/mysql and ext/mysqli drivers for PHP. These rely on the GPL licensed libmysql library, which by its nature is not compatible with the PHP license. With our not-so-optimally-named “FOSS Exception” , we have extended the rights of our community to use MySQL together with a number of non-GPL FOSS licenses, including the PHP license. This solution works well for many in the PHP community.

But we want to do more:

We plan to develop a pure PHP driver for MySQL, to be licensed under the PHP license itself and donated to the PHP Group …