The latest from the MySQL community

Sun's acquisition of MySQL received an "early termination" of antitrust review by Federal antitrust regulators. As a result, Sun/MySQL acquisition has been given a green light.

I’m still working up some good tips and advice on MySQL on Solaris (particularly the T1000, the new x86 based servers like the X4150 and ZFS, amongst other things), but until then I found Getting Best out of MySQL on Solaris while doing some research.

With the latest OpenSolaris builds (b79, from memory) we now have MySQL built-in, and I worked with the folks on the OpenSolaris Database team to get some reasonable configurations and defaults into the system. MySQL 5.1 and 64-bit support is currently going through the process and will be a in future build.

I’ve also been working with the DTrace people to improve the DTrace support we have in MySQL (documentation will go live this week, I hope). MySQL 6.0.4 will have some basic DTrace probes built-in, but I’ve proposed a patch to extend and improve on …

I was reading comments on an article at BusinessWeek about Sun and Jonathan Schwartz, when I came across this gem:

Dude, my son’s college funds are tied up in your stock. He keeps getting older but the stock is still hanging. I have two years for that stock to rocket.

Aside from anything useful I might have to offer Sun… I would like to poke this guy in the eyeball. Why would you ever tie up the entirety of something as important as your son’s college fund in a single stock? That’s stupid. As if diversification weren’t a well-known concept already, I would have thought that maybe people would have learned from Enron. Perhaps this is a dedicated employee trusting in and investing in the company he works for. The really naive, since a tank in the …

A

OK, Sometimes you stumble onto things that are just not right. On my own personal set of hardware (independent from the Server with the IBM Raid card) I am still running Tests with the Mtron flash drives. I noticed a huge regression in performance late this week from earlier in the week. In fact it was truely head scratching. DBT2 results that were in the 26K TPM range suddenly dropped to 4K TPM.I hate to admit a big screw up, but my tests towards the end of the week were tainted. While investigating the problem with the IBM Raid Card and XFS, I took one of the Mtron drives and rebuilt it with XFS. The benchmarks (sysbench) showed that on my hardware their was little performance difference. When I resumed my Mtron dbt2 benchmarks the mtron drive that housed the log files was indeed on this xfs drive.

Trying to figure out what was going on I noticed this (sde is the log drive, sdd is the data ):

A company has come up with a vendor-neutral database certification exam. Some are wondering how much use this will be, as it doesn’t go into vendor-specificities. Now, the specifics of how a query optimizer handles queries, how backups, restores and security are done and with MySQL specifically, how different storage engines act are [...]

There has been plenty of press this week regarding Microsoft making a bid for Yahoo. This week the Wall Street Journal Article From Uncertain Future To Leading Yahoo Bid has prompted me to the following observations. I quote several points:

The bid, he said on the call, is “the next major milestone in Microsoft’s companywide transformation” to incorporate online services.

as Microsoft pushes the bid and, if successful, tries to meld Yahoo with Microsoft.

Microsoft had been negotiating to buy online ad company DoubleClick Inc. but lost that deal to Google, which paid $3.1 billion. Microsoft in May countered, spending $6 billion on online ad company aQuantive Inc.

While Microsoft should continue investing in its own online services, it …

I read yesterday in The Wall Street Journal an interesting article in Personal Technology, “Solid-state drives challenge hard drives in speed, but not value”. While the title does sum up nothing new, the barrier to entry to embracing new technology is always cost, and early adopters may not have deeper pockets, but it’s also about being a alpha geek.

As the article states “Solid-state drives have some key advantages. Because that lack moving parts, they are faster, draw less power, and harder to damage and are quieter”. It also backed this up with some results.

What I did not realize, is the new MacBook Air has a 80GB HHD version at $1,799 and as 64G SSD version at $2,798. Testing showed that there was little difference in battery life between these models, however with the …

Fotolog is seeking a MySQL DBA. You'll be working with me in a fast-paced, small-team-running-a-very-large-scale environment.

About Fotolog.com:
? 14th most trafficked site (Alexa)
? 3rd most active social network (ComScore)
? Parent company: Hi-Media (France)


Duties
? Work with Director of Database Infrastructure to maintain/improve and support a high traffic, fine-tuned, scalable and reliable database environment on a day-to-day basis.
? Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues.
? Optimize and tune contentions within the database environment
? Create logging environment(s) to log usage statistics about the environment
? Regularly monitor and periodically conduct random tests of restoration from backups generated within the environment
? Participate in large storage engine migrations
? …

Yup, Yahoo! has finally decided to show balls and reject Microsoft's bid.

Thinking just from search point of view, a Microsoft-Yahoo merger is less evil for the search economy (and by extension online economy) than a Yahoo-Google deal. Of course, this is based on my biased view.

Update: I wonder how long before YHOO drop back to their pre-Microsoft-bid levels.

Update 2: …