Maybe this is common knowledge by now, but I've seen this problem popping up at work and I've run into it today. I upgraded Fedora 4 to 5 and wanted to get MySQL 5.1.11 on it instead of the MySQL 5.0 delivered with Fedora 5. This also goes mostly for Red Hat EL btw..

These were the things I had to do, on a system without any production databases. Do not do this on production without backups and lots of coffee!

1. 
   
2. Download the generic RPMs from http://dev.mysql.com/downloads/: Server, Client, libraries and headers and the shared libraries. Put them all in one directory.
   
3. run in that directory: rpm -Uvh MySQL*
   
4. If point 2 didn't give errors, you going to have problems starting MySQL.
   
   
5. mysql system user is missing. To recreate it:
   # adduser -d …

Walmart.com is relaunching, and has open source at its core. MySQL? Well, probably (that's a given these days), but this news is even more significant, because it's OpenLaszlo from Laszlo Systems. OpenLaszlo is a great way to add rich media functionality to your website. WalMart agrees.

The real question, given WalMart's reputation for driving down vendor pricing, is how much lower than free did it require? :-)

ADVERTISEMENT
CDW
The Right Technology Right Away. Get a printer you can count on to do what it's supposed to do - print. Get an HP printer from CDW.

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 …

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!