Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 209 Next 30 Older Entries

Displaying posts with tag: work (reset)

The Sun sets
+0 Vote Up -0Vote Down

I no longer work at MySQL/Sun Microsystems. So if you’ve sent any email to {colin|byte}@mysql.com, or {colin.charles|byte}@sun.com in the last month, they’d silently have gone into /dev/null as I have not had access to my accounts. Don’t hesitate to resend them to byte@bytebot.net if you’d like me to see them.

I’ve enjoyed my journey at MySQL, but it just seems like its time to move on. I haven’t left the MySQL community yet, though. In fact, I expect nothing but more active participation in it.

What’s next? I’m going to split my time between working on MariaDB, at Monty Program Ab, as well as Open Ocean Capital. I’ll work with Open Ocean portfolio companies Web of Trust and

  [Read more...]
Sales Engineer Wanted
+0 Vote Up -0Vote Down

Things are growing yet again at work and with it the number of people needed to keep things flowing smoothly. This time it’s the Sales Engineer team that needs a new person, working in the Baltimore/Washington area (our home office):

Responsibilities

  • Provide exemplary pre-sales technical expertise through technical and product presentations, product demonstrations, pilot implementations, beta program administration, consistent communication, and on-going technical consultation.
  • Translate complex technical problems for non-technical clients as well as translating non-technical specifications into precise technical requirements.
  • Meet with clients to evaluate their current systems and needs and make recommendations for software and hardware and integration.
  • Travel approximately 30% in support of sales
  [Read more...]
Just another day at the office…
+2 Vote Up -0Vote Down

OQ Engineer Walter Heck working from Samara, Costa Rica

Life as a Location Independent Professional can be hard at times, and very good at others!

Hibernate Wars: The Query Cache Strikes Back
Employee +1 Vote Up -0Vote Down

Not so long ago, in a galaxy not very far away... a middle-aged programmer battled to free memory from the dark side of the hibernate query cache.  He was successful, or so it seemed. For the query cache memory problems had risen from the ashes -- stronger and more bloated than ever...


What's With All This Garbage?


We hit a case at work (http://www.mysql.com/products/enterprise/monitor.html) (again), where the java server process came to a grinding halt.  It wasn't dead, it just wasn't making much forward progress either.  A quick look at the heap stats showed we were nearly at capacity and that garbage collection was eating all CPU time, thus not allowing any real work to happen.  Looks like it is time to whip out the ol' memory profiler.  This time I went with Eclipse's Memory



  [Read more...]
Database Sharding at Netlog, with MySQL and PHP
+0 Vote Up -0Vote Down

This article accompanies the slides from a presentation on database sharding. Sharding is a technique used for horizontal scaling of databases we are using at Netlog. If you’re interested in high performance, scalability, MySQL, php, caching, partitioning, Sphinx, federation or Netlog, read on …

This presentation was given at the second day of FOSDEM 2009 in Brussels. FOSDEM is an annual conference on open source software with about 5000 hackers. I was invited by Kris Buytaert and Lenz Grimmer to give a talk in the MySQL Dev

  [Read more...]
We’re Hiring Again
+0 Vote Up -0Vote Down

I’ve said before that Message Systems is the best place I’ve worked so far, and we’re looking for more people to join the team.

We’re looking for the following roles:

If you think

  [Read more...]
Why Ruby (and Rails) is Awesome
+0 Vote Up -0Vote Down

I was invited to give a short introduction to Ruby on Rails at Tech Meetup in Edinburgh a couple of days ago. I’d been racking my brain for days on what to talk about — 15 minutes is too short for me to give a meaningful introduction to Rails — and eventually settled on telling a few stories.

The slides don’t make much sense on their own, so I’ve included the “script” of what I talked about too. I deviated quite a bit from the script as I got into it, so hopefully I should be able to provide audio (or, dread the thought, maybe even video) of the talk in due course.

Intro

I’m Graeme. I’m the Managing Director of Rubaidh Ltd, and have been developing Ruby on Rails applications professionally for 3 years now.

Telling Stories

To be honest, I didn’t know what

  [Read more...]
Conversation with Lenz Grimmer
Employee +0 Vote Up -0Vote Down
You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 
Conversation with Lenz Grimmer
Employee +0 Vote Up -0Vote Down
You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 
Conversation with Lenz Grimmer
Employee +0 Vote Up -0Vote Down
You can read my conversation with Lenz Grimmer or look at other interviews conducted by the MySQL community team. 
Drizzle is now my job
+0 Vote Up -0Vote Down
I've been involved with the Drizzle project since very soon after it began, working on it on nights and weekends.

That has just changed. As of today, I'm no longer a MySQL Professional Services consultant, instead I'm part of a new division of Sun

Much of my time is to be spent working on Drizzle, with a focus on plugin interfaces and making it work well in Extremely Large distributed environments.

I will be blogging heavily about what I am doing. How I sort that blogging out between my personal LiveJournal, my (mostly unused) Sun employee blog, and maybe some other blog system, remains TBD.

This is going to be fun.
an observer of his own legacy
+0 Vote Up -0Vote Down
one of the questionable habits i picked up in the run-up to the election is reading andrew sullivan’s blog at the atlantic. his thoughts about the recent interview with lame-duck president bush and how president bush seemed unable to take any responsibility for his own role for the failings of his presidency reminded me of monty’s thoughts on 5.1 being declared “generally available.”
work work work
+0 Vote Up -0Vote Down
was it really almost a year ago that i mentioned that my focus would be shifting from connector/odbc to libmysql? time certainly flies.

after what now seems much too long, i can say that we have carved out libmysql from the server source code, rebuilt its build system (using cmake), and are gearing up for an alpha release. the code is on launchpad, and it builds on all the platforms that the mysql server does. we have a build system set up that runs what scant tests we have on all of the platforms, and the big thing to work one before release is making more tests.

because this source is derived from the 6.0 server code, it has at least one big flaw that needs to get addressed — if you try to use utf-8, it uses the new 4-byte



  [Read more...]
Direct MySQL Stream Access
Employee +0 Vote Up -0Vote Down

Ever wondered what your PHP application and MySQL actually do? An experimental mysqlnd branch will give you full access to the network communication stream. Using a custom PHP stream filter you can then intercept the communication ... but let's start at the beginning:

When talking about mysqlnd - the mysql native driver for PHP - we always mention the fact it's native in a way that we're, when possible, using PHP infrastructure. The most common example here is the memory management. By directly using PHP's memory we can avoid unnecessary copies of data from the MySQL Client Library's memory into PHP memory.

<?php
$mysqli = mysqli_connect("localhost", "root", "",
  [Read more...]
Optimizer Edge cases
+0 Vote Up -0Vote Down
I love teaching EXPLAIN in training classes with the world.sql sample database. One of my favorite edge cases to try and explain to students is:

SELECT Name FROM Country WHERE continent = 'Asia' AND population > 1 000 000 000;


If you add an index on Continent,Population and Population, MyISAM will choose to use the composite index (Continent,Population), whereas InnoDB will choose just the Population index.

It's a simple geography question... all of the countries in the world with > 1B people *are* in Asia. Since both indexes are equally effective, InnoDB chooses to use the one with the shorter key_len, despite the fact it will have to do a second stage check on the data rows to verify this.

I think that this decision (shorter index) is the right one - since unless the database has index pinning, it should







  [Read more...]
boring from another continent
+0 Vote Up -0Vote Down



as celia wrote earlier, we are in riga, latvia for a meeting of the mysql developers. she is holed up in the hotel room working on a screenplay (or maybe in the atrium where the wifi is better), and i am in a presentation about blogging.

celia already posted pictures from our excursion day on sunday (the day we didn’t sit around in the meeting rooms at the hotel). i took some video which i will figure out how to deal with once we are back home.
MySQL Lists via NNTP
+0 Vote Up -0Vote Down

MySQL Lists are available via NNTP, so you can use your newsreader! If only all lists were like this.

Now for the real motivations…

After all acquisitions, things tend to change. We’ve been mostly nudged to migrate to using Sun’s email systems, and you can imagine its fun moving about three years worth of mail from one server to another. Especially, while you’re at the developer’s meeting, with lots of people sucking bandwidth.

The recommended method is to Ctrl+drag (OK, Command+Drag for me on the Mac) folders. This is called pain. My Sieve filters are also not importing without pain.

As a consequence, I’ve unsubscribed from all MySQL Lists. But that’s the point of this post - you can

  [Read more...]
Looking for new Coworkers
+0 Vote Up -0Vote Down

It’s been over two years since I left MySQL to work for Message Systems and I’ve really been happy with things here. I work with a great team on interesting work for a good company who treats us well. Not much more you could ask for.

Except for more coworkers. We’re in need of a few new additions to the 2009 team:

We need engineers and tech trainers, scroll down for the details. If you’re interested send an email to mike@thisdomain!

Technical Trainer / Curriculum Developer

This position designs, develops and delivers online and in-person instructor led trainings on the Message Systems products and services for a variety of audiences including customers, partners and internal staff.
You will design courses and instructional material for everything ranging from short informational quick-
starts to multi-day

  [Read more...]
Looking for Coworkers
+0 Vote Up -0Vote Down

It’s been over two years since I left MySQL to work for Message Systems and I’ve really been happy with things here. I work with a great team on interesting work for a good company who treats us well. Not much more you could ask for.

Except for more coworkers. We’re in need of a few new additions to the 2009 team:

We need engineers and tech trainers, scroll down for the details. If you’re interested send an email to mike@thisdomain!

Technical Trainer / Curriculum Developer

This position designs, develops and delivers online and in-person instructor led trainings on the Message Systems products and services for a variety of audiences including customers, partners and internal staff.
You will design courses and instructional material for everything ranging from short informational quick-
starts to multi-day

  [Read more...]
MySQL Query Analyzer: A Peek Under the Hood
Employee +0 Vote Up -0Vote Down
I had a hard time coming up with a title for this blog post. I really wanted to capture its essence. Several discarded titles include, but are not limited to:
  • How It Works
  • The Gory Details
  • Everything You Never Wanted to Know
  • The Insider's Perspective
I picked the lamest one, hoping that it is catchy enough to ensnare the unfortunate soul that comes across my blog. Just in case you don't know by now, I work for MySQL (ok, Sun) on the Enterprise Tools team. We're approaching (some sort of) release of MySQL Enterprise Monitor 2.0, with the headline feature Query Analysis.

What I want to achieve with this article is to give definitions, data, flow, etc., that describe how we look at things internally in the architecture of the application. This is intended to give the hapless reader an idea of what Query Analysis can

  [Read more...]
MySQL and the Missing Rows
Employee +0 Vote Up -0Vote Down
I was doing some multi-threaded, multi-transactional testing for the backend of the MySQL Enterprise Monitor. I came across a weird failure, where it appeared I was able to successfully insert a row, and then (in the same transaction), a select from the same table did not return any rows.

Consider the following transactions:


mysql> create table t1 (id integer primary key auto_increment, name varchar(32) unique) engine=innodb;

a> begin;

b> begin;
b> select * from t1;

a> insert into t1 values(null, 'oldag');

b> insert into t1 values(null, 'oldag) on duplicate key update id=LAST_INSERT_ID(id);
(b blocks)

a> commit;

(b is released)
...
Query OK, 0 rows affected (0.00 sec)
b> select * from t1;
Empty set (0.00 sec)
























  [Read more...]
need anything dampened?
+0 Vote Up -0Vote Down
drizzle is an interesting new development in the mysql landscape. brian aker, who came along to sun microsystems in the acquisition but is actually now part of sun labs, not the database group, has taken the mysql server and started to strip it down to the bare metal. he isn’t working alone, of course, but has picked up some contributors during the stealthy period before they announced it at oscon on tuesday.

if you were paying attention the other day, you may have dug around my launchpad code page and noticed that i had a branch of drizzle where i was applying some fixes to make it build on mac os x. that should be merged into the main tree soon, so that branch will soon be retired. i’m not sure what i might try to do next.

drizzle isn’t



  [Read more...]
my mac essentials
+0 Vote Up -0Vote Down
whenever i see somebody’s list of essential mac applications, i am always a little surprised at how little overlap it has for me. now that i’ve mostly switched over the new macbook pro, here’s the list of applications that i have installed:
  • acorn ($50): this is a nifty little image editing application. in the last few days, i have been using it to mock up shelving layouts for the store.
  • bzr (free): this is the distributed version control system of choice at mysql these days.
  • busysync: it would be nice to keep my google calender and ical in sync. after giving spanning sync a try for a bit, i am giving this a try as an alternative.
  • delivery
  [Read more...]
Using Selenium RC with multiple users
+0 Vote Up -0Vote Down

Zachary Fox (from Alert Logic too) wrote a very good tutorial on how to run Selenium RC to execute unit tests in a team environment.

If you have multiple users running unit tests concurrently against the same Selenium RC server, some nasty things may happen. Zach explains how to properly setup multiple Selenium RC servers, so everyone can work on their own server.

Hibernate: Cache Queries the Natural Id Way
Employee +0 Vote Up -0Vote Down
I work on the MySQL Enterprise Tools (http://www.mysql.com/products/enterprise/monitor.html) team, formerly of MySQL and now with Sun Microsystems. The 2.0 version of the Enterprise Monitor is well under way. As part of this, the Java server backend has been refactored to utilize Spring and Hibernate. Honestly, I didn't know either one of those technologies before starting this project. Oh, what a fun road it has been...

A big draw for using an off-the-shelf ORM was so that we didn't have to write our own (kind of bad and slightly wrong -- those darn transactions) caching implementations for the custom one-off ORM that existed previously. A lot of our internal meta-model is very static, so clearly caching

  [Read more...]
Kickfire makes it easy to be green (and to save some too)!
+0 Vote Up -0Vote Down
Kickfire has announced (as of April 14th, 2008) record breaking results in the TPC-H(tm) Price/Performance category at 300GB and also in overall performance in the non-clustered category at 300GB.
You can find the official results here on the TPC(tm) (Transaction Processing Performance Council) website:
http://www.tpc.org/tpch/results/tpch_price_perf_results.asp
http://www.tpc.org/tpch/results/tpch_price_perf_results.asp?resulttype=noncluster

While the amazingly low price of the Kickfire Database Appliance 2400 will grab you (only about twice the price of a typical 4U MySQL database server) -- the amazing performance per watt is truly incredible. The 3RU Kickfire appliance used in the 300GB volume test consumes




  [Read more...]
bug tracking and code review
+0 Vote Up -0Vote Down
i was going to write some reactions to an observation that postgresql has no bug tracker and its discussion last week, but lost the spark and abandoned the post after a few days. but today i ran across a quote from linus torvalds that neatly sums up my thoughts:

We’ve always had some pending/unresolved issues, and I think that as our tracking gets better, there’s likely to be more of them. A number of bug-reports are either hard to reproduce (often including from the reporter) or end up without updates etc.


before there was a bug tracking system for mysql, there was a claim that all bugs were fixed in each release (or documented), and there has been a lot of pain in seeing



  [Read more...]
On-boarding at Sun Microsystems
Employee +0 Vote Up -0Vote Down
Two month have passed since the close of the Sun-MySQL-Deal, two months of uncertainty whether it's a good idea to join Sun or not but after consulting my ElePHPant, who read the 18 pages of the contract and related documents (including MySQL termination agreement, data privacy agreement, ...), I'm quite optimistic and look ahead to a sunny future. Therefore I'll be a true Sun employee as of tomorrow, May 1st.

connector/odbc 3.51.25 and 5.1.4
+0 Vote Up -0Vote Down
connector/odbc 3.51.25 and 5.1.4 were released today. the new 5.1 release has been deemed “generally available,” which is our really ridiculous term for a non-alpha/beta/rc release.

it was the day for the connectors team to do releases — previews of connector/openoffice.org and pdo_mysqlnd made it out before us, and i believe that a connector/net release is in the wings.
connector/odbc 5.1.3 (release candidate!)
+0 Vote Up -0Vote Down
yeah, it is all odbc, all the time here, it seems. that is just because i can’t write about the really exciting stuff. soon!

that is not to say that releasing mysql connector/odbc 5.1.3-rc is not a huge milestone! it took us a while to get there, but we finally have a unicode-aware odbc driver that is, in our opinions, production-ready. now we just need some community feedback to find out if we are right. there are a few minor issues we know about already, but the impact of those is generally small enough that the majority of folks should not have any problems.
Previous 30 Newer Entries Showing entries 61 to 90 of 209 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.