Open Query blog

I was reading Colin Charles’ write-up of Does Open Source need to be “Organic”? (with Brian Aker, Rob Lanphier, Stephen O’Grady, Theodore Ts’o). I’ve been thinking about this a bit, and I’m going to put out a hypohesis here…. see what you think:
I think that overall, dual licensing as a large scale business model has [...]

Filed under: Uncategorized | by arjen
13 Comments »

This DBA course day is in part based on info from Peter Zaitsev’s earlier explorations (thanks Peter), and of course new insights from the High Performance MySQL book (there’s a lot of Baron in there, all credit to his great work!), wisdom from Mark Callaghan, with my own teach approach and style thrown in to [...]

Filed under: Uncategorized | by arjen
4 Comments »

Sebastian Bergmann’s slides of his presentation at OSCON this week. Quality Assurance in PHP Projects is a workshop by Sebastian (author of PHPUnit) in Melbourne (4-6 August) and Brisbane (11-12,14 August), on my invitation. This was triggered by meeting up with him earlier this year at the MySQL Conf in Santa Clara, and a discussion [...]

Filed under: Uncategorized | by arjen
No Comments »

Today Brian launched Drizzle, something he’s been working on for a number of weeks now, together with some other Sun/MySQL people and quite a few active MySQL community members. I scribbled some quick info and my own perspective on About Drizzle, with links to the various currently available resources.
I think it’s an interesting and worthwhile [...]

Filed under: Uncategorized | by arjen
No Comments »

Related to my post earlier today about the use of MySQL 5.0 and the Open Query course on upgrading and new features… I thought it might be good to do a broader poll of the MySQL population and see what version people are using for development (not deployment) right now!
Use this link to go directly [...]

Filed under: Uncategorized | by arjen
3 Comments »

MySQL 5.1 is nearly GA (not debating that fun now , MySQL 6.0 has interesting new magic such as Falcon and online backup. But I still have many clients that are on MySQL 4.0 or 4.1 both in production and development. Works fine, overall, but quite a few problems would be nonexistent if they [...]

Filed under: Uncategorized | by arjen
1 Comment »

Sometimes you don’t quite know what to think… last month MySQL (the company) had no courses in Australia listed in their schedule. They do a few courses a year, schedule them, and they disappear from the schedule when they’re full – which, given one active MySQL salesperson since the start of the year, is happening.
Anyway, [...]

Filed under: Uncategorized | by arjen
5 Comments »

Good idea: WhoCallsMe?. Tracks nuisance calls (globally), of course only if there’s a CallerID. Check on the site if the number is already in the system, read the comments, add your own. Simple, but useful.

Filed under: Uncategorized | by arjen
No Comments »

my.cnf can take the open_files_limit=N option in the [mysqld_safe] block. This doesn’t do anything to mysqld directly, instead the mysqld_safe script calls ulimit -n <N>
These days, we might want to limit mysqld to use a maximum of 4 cores (using taskset on Linux) so InnoDB performance doesn’t degrade. Of course this is only relevant on [...]

Filed under: Uncategorized | by arjen
4 Comments »

Interesting comment spotted on Jonathan Schwartz’ blog:
[...] I work for a major Fortune company, and we’re in the process of putting Oracle on a “sunset” list of restricted vendors. No new applications are allowed on Oracle, the only approved vendors are Sun/MySQL and Microsoft/SQL Server. So I don’t know how Sun did that, but if [...]

Filed under: Uncategorized | by arjen
2 Comments »