Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Like in the years before, I (and some other colleagues from
MySQL) will be attending FOSDEM 2008 in Brussels, Belgium on February 23rd
and 24th.
The schedule is packed as usual and lists several MySQL-related topics and sessions:
The first point I’d like to make is that you’re using a Microsoft Windows API, so you have already lost. You are just not quite aware of how much you have lost.
A quick look around and you say “Ahh… GetFileSize, that’s what I want to do!” Except, of course, you’re wrong. You don’t want to use GetFileSize at all. It has the following signature:
DWORD WINAPI GetFileSize( __in HANDLE hFile, __out_opt LPDWORD lpFileSizeHigh );
Yes, it supports larger than 4GB files! How? A pointer to the high-order doubleword is passed in! So how do you know if this errored? Return -1? WRONG! Because the high word could have been set and your file length could legitimately be 0×1ffffffff. So to find out if you actually had an error, you must call GetLastError! Instead of one call, you now have two.
The Microsoft documentation even acknowledges that this is stupid: “Because …
[Read more]Dave Rosenberg once wrote that the winner in a given open-source category (ERP, CRM, etc.) takes all. There's no room for second place. The first mover to get critical mass tends to horde the community and media resources.
I didn't believe Dave at the time, but after looking through the data from Alfresco's Open Source Barometer survey, I'm becoming more and more convinced.
The Barometer now comprises a data set of 35,000 enterprises, a significant percentage of which hail from the Global 2000. In the case of open-source databases, these enterprises are overwhelmingly voting for MySQL, …
[Read more]
Last week, I described how to use the MySQL plug-in API to write a minimal 'Hello world!' information schema plug-in. The
main purpose of that plug-in is to illustrate the bare essentials
of the MySQL information schema plug-in interface.
In this article, I'd like to take that to the next level and
demonstrate how to write an information schema plug-in that can
access some of the internals of the MySQL server. For this
particular purpose, we will focus on a plug-in that reports all
the SAVEPOINTs available in the current
session. This …
This release contains minor bug fixes and new features. Besides the little bug fixes, there's a fun new feature in mk-heartbeat: it can auto-discover slaves recursively, and show the replication delay on all of them, to wit:
baron@keywest ~ $ mk-heartbeat --check --host master -D rkdb --recurse 10 master 0 slave1 1 slave2 1 slave3 4
(Not actual results. Your mileage may vary. Closed course, professional driver. Do not attempt).
Nothing else in this release is very exciting. I just wanted to get the bug fixes out there.
After five days of powder skiing and mountain climbing on ski, I’m back in business. This is how I looked out-of-business:
My son and I did not meet with Ötzi the Iceman, but we got a few blisters, a lot of Alpine sun, plenty of powder skiing and the experience of climbing more than 1000 height metres to K2 (in Tirol, not its namesake in Karakorum). And we conquered Austria’s second highest peak, the Wildspitze at 3772 metres above sea level.
The group consisted of our Austrian mountain guide, four ladies and four gentlemen, all of which were German …
[Read more]Fabrizio makes a good point in his blog highlighting Openbravo's success but potentially also a shortcoming: The company is based in Barcelona, not Silicon Valley. For people in the Valley, the Valley Fetish is very strong. It is, after all, the source of all light and truth.
Fabrizio's point is unintentionally cynical: If you want to get bought for a "gazillion dollars," move your company to the Valley:
Why Silicon Valley for open source? Beside funding and partnering, think for a second about the open source companies that have been bought lately for gazillion of dollars: MySQL, Zimbra, Xensource, Trolltech. Where were they based? Utah? Barcelona? I do not thing so. They maybe started somewhere else, but they were headquartered in the Valley.
Where are the customers in that statement? The …
[Read more]More interesting stuff here. I reran the XFS tests yesterday, same old story. The generic sysbench disk ( on mtron ssd ) tests show this:
EXT3:
Operations performed: 5001 Read, 4999 Write, 12800 Other = 22800
Total
Read 78.141Mb Written 78.109Mb Total transferred 156.25Mb
(3.1325Mb/sec)
200.48 Requests/sec executed
XFS:
Operations performed: 5006 Read, 4994 Write, 12800 Other = 22800
Total
Read 78.219Mb Written 78.031Mb Total transferred 156.25Mb
(1.7767Mb/sec)
113.71 Requests/sec executed
The dbt2 tests also reconfirm this. Simply putting the innodb log files on the XFS filesystem caused the loading of the database to go from 29 minutes 43 seconds to 56 minutes 23 seconds. The DBT2 test results dropped in one test from 21K New order TPM’s to 3.7K New Order TPM’s. I am going to rerun this test in Ubuntu to see if this is a Redhat/Centos package problem. I may also try …
[Read more]
MySQLConf.com uses a non-optimal temporary 302 redirect to the
MySQL conference website.
This is very bad for mysqlconf.com domain name and equally bad
for people who link to http://mysqlconf.com (instead of linking
to en.oreilly.com/mysql2008/) as their links then DON'T BENEFIT
the conference site and from Google's point of view they are
linking to a page that engages in temporary redirect. The result
is unless you link directly to an oreilly.com page for your
conference links, your votes/links don't get passed on to the
conference site.
A 302 redirect is considered bad from search engine's point of
view due to its temporary nature.
So please folks, change the redirection to 301 or I will have to
go back and change my links to be "rel='nofollow'" links.
Currently, the site gives:
wget …[Read more]
This year MySQL Conference features some of the best talks
on InnoDB and
I couldn't be more excited. We'll be hearing from Heikki Tuuri,
Ken Jacobs, Mark Callaghan, Vadim Tkachenko, Peter Zaitsev and me
:)
Kudos to conference organizers have really done a great job in
balancing the sessions this year.
MySQL conference is a great venue to get up to date with what's
happening with your favorite database/storage engine. Early
registrations end soon so save yourself some money and register now.
If you have known me for sometime or if you are a regular blog
reader, please send me a note and I will send you a coupon code
to save even more when you register at the conference. You can
email me at …