A few months ago on planet-php.net, I came across funcaday, a wonderful idea “developed by self-proclaimed PHP guru Paul Reinheimer and Graphic Design lackey Courtney Wilson.”

Basically, funcaday is a run-down of PHP functions, with a short description and a few hints on how to use them. Having programmed PHP for about a decade, I can safely say that I feel pretty well-versed in the PHP universe. Still, I’ve had at least two “Aha!” moments in the time I’ve kept up with the sites’ RSS feed. I think this is a great idea, and believing that MySQL deserves something like it, I’ve decided to follow up with a similar “service” to those interested.

Since I don’t have a graphic designer handy, I guess …

Sheeri always amazes me. When I think that I have seen all it has to be seen in the field of databases, she will always come with some innovative way of looking at old things.
This session is a series of aha! ideas. Some of them can have come to you. You may have heard of some others, but Sheeri does not stop at that. When she hears about a promising practice, she digs in, until she gets all is there to be learned.
She's a captivating speaker. Once you attend one of her sessions …

(Credit: Mozilla)

I just downloaded Mozilla's Firefox 3.0 Beta 4, and loved what I saw:

See that? Firefox is localized into a wide range of languages, which is great. But what I appreciate even more is that it treats Windows, Mac OS X, and Linux as peers. In Microsoft's world, software runs solely or best on Microsoft's operating system, database, etc. Given the chance, most proprietary software companies behave like this.

Not Mozilla. Not Eclipse. Not Zimbra. Etc.

There's something about open source that speaks up for the potential user who isn't part of the mainstream. Somebody, somewhere, is like that person and has contributed the code to bring the outsider in.

...

As Matt reported last week, IBM announced that it was bowing out of the solidDB for MySQL project. "Those of you who know Solid's history know that Solid has long been a leader in the area of in-memory database software. This in-memory technology, and not Solid's open source offering, was the key driver behind IBM's acquisition. As a result, I regret to inform you that, effective immediately, we will not be continuing further development on solidDB for MySQL. solidDB for MySQL will continue to be hosted and available here at SourceForge, and existing releases will continue to be available under... READ MORE

MySQL is hiring for Sales Engineering in APAC.  The jobs are location independent, but priority is given to applicants that are nearest our key customer concentrations.  Please contact us if you feel you are qualified.

Larry Stefonic

The SnapLogic.org site runs on open source software, including a lot of Python. The bottom of the stack is RedHat Linux, the web server is Apache, the database engine is MySQL, and the main applications are Mailman, Subversion, Trac, Wordpress, and a custom Django application.

All of these pieces play together pretty well, and over the past year we’ve only had a few minor problems to fix. But over the past couple of weeks, we’ve really been hitting Trac hard as we work through our upcoming release, and Trac performance was bad. Really Bad. Like, ‘30 seconds to open a ticket‘ bad.

It’s hard to say if this was a sudden performance drop because we crossed some magic threshold in database size, or if it was slowing getting worse and we really noticed it when we shifted from design to coding. In any case, there are only 1000 tickets in the system so we knew something was wrong.

We turned on the …

We were using memcache in our application for a long time and it helped a lot to reduce DB servers load on some huge queries. But there was a problem (sometimes called a “dog-pile effect”) - when some cached value was expired and we had a huge traffic, sometimes too many threads in our application were trying to calculate new value to cache it.

For example, if you have some simple but really bad query like

SELECT COUNT(*) FROM some_table WHERE some_flag = X

which could be really slow on a huge tables, and your cache expires, then ALL your clients calling a page with this counter will end up waiting for this counter to be updated. Sometimes there could be tens or even hundreds of such a queries running on your DB killing your server and breaking an entire application (number of …

It's time for the 2008 MySQL Conference. This year should be especially interesting. Sun announced they would acquire MySQL on Jan. 16 - fewer than eight weeks ago (I bet it doesn't seem that way to the folks involved). The deal was closed only Feb. 26, and I'm sure there are still months of work to go, to fully integrate the two companies. Exciting times!As always, database server technology

With the great help we receive from community and SE Beta testers we are marching towards RC quality with large steps. This week we hope to remove the last obstacles (mostly printing, some canvas problems and some synchronization problems) that are holding us back and to be able to close all open P1 & P2 bugs. If we achieve all this we will upload the RC1 (Release Candidate 1) build.

As a bonus we have now added the much requested “direct connection” notation between columns (better know as MS Access style notation) to the Standard Edition - a feature that has been requested since the old DBDesigner4 days. Personally, I am not so found of this notation because it limits the connection points to the left and right of the individual PK- and FK-columns which makes it harder to have a nice looking model. But given the flexibility of Workbench to hold an unlimited number of smaller diagrams this might solve this problem for most I hope.

This is the first place I am announcing this: The Pythian Group has made me a Team Lead. I am extremely honored and somewhat humbled by this, and I am determined to do a good job. I started officially on Monday, March 3rd, and my first week went pretty well. On [...]