Note: For the impatient, here's a direct link to the example that highlights itself:

http://shiflett.org/code/highlight.php

As I mentioned in the previous post, shiflett.org is being redesigned and redeveloped from the ground up. (Nope, it's not finished yet; you'll know it when you see it.) One of the things I want to improve is commenting. This blog has been getting a lot of comments, and I really appreciate that. (Thanks!) Since the topics I talk about (PHP, MySQL, etc.) are technical, I want to let you add formatted code listings to your comments.

I've been playing with this tonight. Feel free to follow along as I go. The first thing you want to do is create an ordered list from the code you want to format ($code in these …

In a dramatic twist on Oracle's news yesterday that it will be offering support for Red Hat's Enterprise Linux, word on the street is that MySQL is considering offering support for Oracle's venerable database.

The hitch, however, is pricing. Early estimates suggest that MySQL would need to charge 1000% the cost of Oracle's typical pricing to make a profit on the support, given the persistent bugginess of proprietary databases compared to MySQL.

/tongue in cheek :-)

ADVERTISEMENT
…

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 …