I am waiting and seeing how this new MySQL Enterprise Edition shapes up and how it affects the Community Edition, the Community, and MySQL users as a whole, but everything I have heard about it so far, from official press releases, initial public feedback, and information given to me, I am very impressed with it. This move shows every sign of being well-planned, designed to work positively for all parties concerned, from MySQL staff to paying customers to community members. What I see is added value for paying customers, better reasons for purchasing the paid edition, a focusing of MySQL's resources to better develop the product as well as to devote support to their customers, and importantly, an enabling of the community to be even greater participants than before. Some things taken for granted by some community members such as frequent binary updates may cause some disappointment, but I view this as a small price to pay, and an encouragement to …

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 …